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?