Re: Oracle 8.0: select statement with order by runs too long

Try:

	SELECT * 
	FROM folders
	WHERE selekt nr1 > 0;

Set timing on and let us know if you see any improvement.

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 7/26/00, 5:06:31 AM, Bernd Rosenau <brosenau_at_gss-online.de> wrote regarding 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 Thu Jul 27 2000 - 00:00:00 CDT