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

Try setting the session to all rows rather than first rows to see if that helps the throughput.

Maybe try changing the order of tables in the sql to event, document, ebiz... and use the ordered hint. The general idea being to filter as much as possible up front, and the event_x1 range scan with a specific unit number looks to me like it might do that, while the optimizer seems to think the document table unique scan does.

jg

--
@home.com is bogus.
Swarming robots of death:
http://www.signonsandiego.com/uniontrib/20060419/news_1b19robots.html