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

When using the ORDER BY clause, the database performs a sort on the data that you are retrieving and also performs a full table scan.

Kevin

<dorutanasa_at_my-deja.com> wrote in message news: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 - 05:42:37 CDT