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

             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 - 09:20:07 CDT