Re: Performance Problem

Hi Steve,
Thanks for giving the tips and explaination.

Lewis,
Very informative !! The way you suggested to try executing query mannually , It is really a good tip. That's way I somehow guessed (not surely) that a full scan and Hash Join may help as Nested Joins are worst with large joining tables.
your explaination for NOT IN & Hint of push_subq really nice & informative.

Thanks all for contributing.

With Warm regards
Jatinder Singh
stevedhoward_at_gmail.com wrote:

> Well, it looks like you got your wish with the HASH JOIN and the Full
> table scans....but as a result, you are spending all your time waiting
> on the full scans, i.e., db file scattered read( that alone almost 6
> minutes of your total wait. Did you change the statement. If not, did
> you do anything else between Friday and now that would change the
> execution plan?
>
> Try splitting up the statement between the UNIONs to see which one (or
> both) are slow. Once you find the slow one, start taking out pieces of
> it until it runs fast.
>
> Do you have recent statistics calculated on the tables?
>
> Regards,
>
> Steve
Received on Tue Apr 25 2006 - 23:56:44 CDT