Re: Performance Problem

From: <stevedhoward_at_gmail.com>
Date: 24 Apr 2006 07:03:04 -0700
Message-ID: <1145887384.863114.71610@e56g2000cwe.googlegroups.com>

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 Mon Apr 24 2006 - 09:03:04 CDT