>>>>Interesting. Should I put it in every index I created on this cursor? This cursor is always in some order by one of the fields...
>>>
>>>Of course.
>>
>>The question now is: should I go ahead and try it or live the working solution in place (the cursor has less than 100 records usually) and concentrate on the other problems? < g >
>
>Nadya, now you known the solution,
>then you can put it into the Jobs Queue;
>set the priority value, your prerogative is one.
>
>Sure, to implement FOR NOT DELETED() on table's indexes
>demands one total analysis.
BTW, looks like I never answered this thread. Yes, that's the solution I finally went with.
If it's not broken, fix it until it is.
My Blog