yes Doug,

I have not yet narrowed it down yet, but if time permitts, I will continue to pursue this anomaly. I do not expect to get much time to work on this however. You know how it is "The sqeeky wheel gets the oil" Well this wheel's not a squeekin anymore.


>Hi Glenn.
>
>>After I used STD to reindex the table the expression is no longer Rushmore optimized.
>
>SDT is ultimately (after a ton of work <g>) just doing an INDEX ON using your expression, so I can't see how it would be a factor. I see from a later message you've narrowed this down to an environmental factor.
>
>Doug