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 -> Oracle 8.0: select * with order by lasts too long

Oracle 8.0: select * with order by lasts too long

From: Bernd Rosenau <brosenau_at_gss-online.de>
Date: 2000/07/26
Message-ID: <9vdtnskcvediduavncd98h1j8e4ul0jak3@4ax.com>#1/1

Hello,

the following statement needs 20 seconds for execution when run on a 65000 rows table:

select * from folders order by selekt_nr1

Selekt_nr1 is an index-field but Oracle does not seem to use the index.

Without the ORDER BY i get an almost instant response.

Any ideas ?

Many thanks in advance for your help,

Regards, Bernd Received on Wed Jul 26 2000 - 00:00:00 CDT

Original text of this message

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