>>>Hi Andreas!
>>>
>>>Did you have an index on Deleted() expression too? It seems like your
>>>filter is partially optimized...
>>>
>>>Have a happy day
>>>Vladimir Shevchenko
>>>
>>Can you explain why an index on Deleted() is important for optimization?
>>Is the effect of not having a index on Deleted() about the same as not having
>>a index on another field which is part of the filter? Thanks!
>>
>>Paul Wei
>
>Because Rushmore use the deleted() Index for optimization. I don't think the difference between having one and not having the index on deleted() is very huge. But it makes a diffference. The diffference increase with a lot of deleted records in your table. But if you want to full optimization you mus use the index deleted().
>
>Try using SYS(3054,11) to see the level of optimization of your queries.

I know it was just a typo, Sonny, but...

SYS(3054,1) is the command needed. VERY useful.

Barbara