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