Clarity

  • Private Community
 View Only

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

    Posted Nov 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 Nov 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

    Broadcom Employee
    Posted Nov 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