Jason,

> What I do is add a +0 to date columns and this effectively drops the index
> and then a plan is not needed. With strings you can use || '' and this will
> accomplish the same thing.
>
> The optimizer cannot use an index for a computed value in a comparison...

this is interesting, I never thought about that.
Anyway, I need to have the optimizer use the one meaningful index.
Your solution would make it not use any indexes (indices?), wouldn't it?
Thanks
--
____
_/\/ando