Re: Why a Select with Order By takes such a long time to complete on a complex view?

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?

From: Stefan Grundmann <s.grundmann_at_t-online.de>
Date: Tue, 29 Aug 2000 18:24:00 +0200
Message-ID: <8ogooa$q25$10$2@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 Tue Aug 29 2000 - 11:24:00 CDT