Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Using Indexes
Without WHERE clause NO INDEXES will be used, no matter what
David Pais
DelphiDev wrote in message <36DAC9AF.6A9E74C9_at_yahoo.com>...
>I have submitted the following statements to SQL Plus 3.3 on Oracle 7.0:
>
>SELECT IDCODE FROM PERSONEL ORDER BY IDCODE;
>
>This query takes a fair amount of time. I then index it and run the
>query again:
>
>CREATE INDEX IDCODEINDEX ON PERSONEL(IDCODE)
>SELECT IDCODE FROM PERSONEL ORDER BY IDCODE;
>
>The query seems to take the same amount of time to "Order" the records
>before actually printing them. I assume that if a index is present then
>Oracle will take advantage of it. This doesn't seem to be the case.
>Could someone explain this?
>
>Thanks, Stan.
>
Received on Tue Mar 02 1999 - 15:53:36 CST