>First - we are not using conversions in indexes, it was just a thought.
>Second - that's an idea, but it's that like a conversion anyway?
>Thrid - still got same results with your subquery example. Still doing an INDEX scan on cStatus.
>
>I just can't beleive oracle is this stupid to not see that the date range is going to be so much faster.
>
>TIA

Mark,
The second option does not do a convert. In VFP, to combine index expressions you have to use the + or - operator. In Oracle, you simply define the fields to use as the index expression.

create index myindex on mytable 
   ( field1 asc,
     field2 asc,
     field3 asc)

Field1, field2 and field3 do not have to be the same data type.

One other option is to drop the index on cStatus entrirely.