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?
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.
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.