Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Why a Select with Order By takes such a long time to complete on a complex view?
When you do an order by it will take more time, beacuse it needs to sort the
data.
Execute you select satement and check the execution path.
Aslo check your temp table sapce.
Tom
Stefan Grundmann <s.grundmann_at_t-online.de> wrote in message
news:8ogooa$q25$10$2_at_news.t-online.com...
> Hallo Doru!
>
> Check your columns in the join-condition of the view for missing indexes.
>
> Stefan.
> <dorutanasa_at_my-deja.com> schrieb in im Newsbeitrag:
> 8oggq0$9eo$1_at_nnrp1.deja.com...
> > Hi everybody,
> >
> > First of all, I just a beginner so please excuse any mistake that I
> > would
> > probably make.
> >
> > I needed to create in my database a view that use aprox. 12 tables. My
> > view
> > has over 30 columns, but using indexes in the base tables a select
> > doesn't
> > take so long (max 2-3 sec).
> > Now, I want to use the ORDER BY clause in the SELECT statement, but
> > can't do
> > it because it takes too loooong time to be executed.
> > Any idea why this happend... would be sincerely appreciated.
> >
> > Thanks,
> > Doru.
> >
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Wed Aug 30 2000 - 02:13:55 CDT