I'm pretty sure that filtered index are not Rushmore optimisable. So that would make it slower. Do you have an index on SearchTB?

>I'm thinking, could it be better to use filtered index instead.
>
>E.g. currently I do:

>scan for m.plError=.f. and SearchTB = m.lcSearch and not empty(InsCommand)

>May be it would be faster to set a filtered index and do seek, when scan while?
>
>However, as I recall, I tried similar idea (in another context, though) and it actually slowed it down.