Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Query takes too long to execute
<mylesv_at_gmail.com> wrote in message
news:1163648234.305839.213870_at_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
>
Good you have eliminated one possibility.
Jim
Received on Thu Nov 16 2006 - 20:46:40 CST