INDEX on DATE field.

I'm querying a table, searching for all fields mathching a date range. So I I have a regular index on my TRANDATE column, and my queries look like (ie all records for october 5th 2000)

    SELECT ...... WHERE TRANDATE >='10/05/2000 00:00:00' AND TRANDATE <'10/06/2000 00:00:00'

How can I avoid

1. index range scan?
2. a sort for this index?

Is that even possible? obviously bitmap indexes don't help here

any ideas? Received on Sat Aug 05 2000 - 00:00:00 CDT