Using Indexes

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 Mon Mar 01 1999 - 11:09:03 CST