Oracle 8.0: select statement with order by runs too long

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