>If I index a file on a function like
>
>index on SqueezeDesc() tag Xdesc
>
>then query optimizations take advantage of the expression ie.
>
>select * from xFile where squeezedesc() = 'ABC' (Fully optimized)
>
>After I used STD to reindex the table the expression is no longer Rushmore optimized. What is a workaround for this problem?
I did not think that could ever be optimized. What does KEY(n) return? Does it return SqueezeDesc()?
Mark McCasland
Midlothian, TX USA