Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8.0: select * with order by lasts too long
because you're doing a 'SELECT *' it will read the whole table and not use the index. Without the ORDER BY it will not need to do a sort, it simply reads to sends it.
SH
Bernd Rosenau wrote:
> 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