Index by Date Descending: Ignored

This seems like a basic problem, but a search of the newsgroup yielded no similar answer.

I have an index on a "users" table by a date field (column "record_create_date") in descending order. We're running 8.1.5.0.2

They query "SELECT * FROM USERS ORDER BY RECORD_CREATE_DATE DESC" *never* uses this index.

Does it have anything to do with he fact that I create the command using:

   CREATE INDEX USER_CREATE_DATE_I ON
     USERS(record_create_date DESC) ;

But if I look at the script for the index (via the Toad schema browser) I see:

   CREATE INDEX USER_CREATE_DATE_I ON
     USERS(SYS_NC00079$); Any suggestions? What obvious point am I missing?

thanks,

bill milbratz

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 12 2000 - 14:14:35 CDT