Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Query takes too long to execute

Re: Query takes too long to execute

From: Jim Kennedy <jim>
Date: Thu, 16 Nov 2006 18:46:40 -0800
Message-ID: <MfGdna_vdOEsvMDYnZ2dnUVZ_rednZ2d@comcast.com>

<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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US