Re: Query takes too long to execute

From: <mylesv_at_gmail.com>
Date: 15 Nov 2006 19:37:14 -0800
Message-ID: <1163648234.305839.213870@b28g2000cwb.googlegroups.com>

Jim Kennedy wrote:
> 1. If you take the order by off does the query take a lot less time? If so
> then the sort is going to disk. The time difference would be the cost of
> sorting the results. You could make the sort area size larger if that is
> the issue.
> 2. Are the tables and indexes analyzed?

Thanks for the reply, Jim!

The results are the same with and without the sort. It's the join that's killing me, I think. I analyzed all tables and indexes a few days ago. Note that I did an _estimate_ statistics with a 33% sample size. Perhaps I should try it with "compute statistics".

Thanks again,
Myles Received on Wed Nov 15 2006 - 21:37:14 CST