>Hi Bruce!
>
>Have you index on Deleted()? Is the left side of WHERE clause match the
>index expression?
>
No, no Deleted() for this (yet), left side of Where is matching. In the simplest case, where I have only simple index on a field, and I get "partial" optimization, but never full. Do you think that's the best possible? I thought SQL would run fully optimized with the right setup...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.