Re: Horrible Query Performance, Simple Query -- Performance Tuning Help Needed

Thanks for the responses. When we remove the HDD_TRAN_2000 function call, the query still runs slow.

I've run the query using the ALL_ROWS optimizer hint and it didn't seem to make it any faster.

I'm not sure how to make the optimizer use another join type besides Nested Loops. Do you have any examples of what I might be able to do? I have tried taking the joins out and doing things like:

select BLAH from (select EventID from Event where unitNumber=####) join on XXX

but that didn't make it any faster either.

Isn't the elapsed time so big because the database was waiting for the data to be brought back from disk? What kind of test could I do to determine what is the bottleneck?

Again, thanks everyone for their help! Received on Wed Apr 19 2006 - 16:30:32 CDT