Clarity PPM

Expand all | Collapse all

Need advise on faster performing queries for the purpose of a custom table

  • 1.  Need advise on faster performing queries for the purpose of a custom table

    Posted 11-06-2018 03:24 PM

    We have a long query for audit analysis and it takes practically forever in our oracle environment.  Essentially it does comparison between and among various audit data.  It's rather complex and it takes a long time to run.  We're trying to create a customiized table off of this.  Does anyone have any good methods to get this to perform faster?



  • 2.  Re: Need advise on faster performing queries for the purpose of a custom table

    Posted 11-07-2018 12:45 AM

    I've used Toad's SQL Optimizer on long running queries.

     

    How about sharing your SQL you are trying to run, as we may be able to spot items as well.



  • 3.  Re: Need advise on faster performing queries for the purpose of a custom table

    Posted 11-07-2018 03:58 AM

    Hi julian926,

     

    Once I had heavy query and I used Oracle Materialized view to improve query performance.

    I think it is one of solution to improve query performance.

    As you know, it is not supported option.

     

    Regards,

    Shoichi