>What do you base that on? I've seen HUGE improvements in query performance achieved by adding a tag on DELETED().
Hi Josh, PMFJI, but I tested the same way Walter did with NOFILTER on. The Deleted index provided no benefit at all, possibly even slowing the query down a bit (though it was very close in my limited test). I have to use NOFILTER, else we get some major problems with creating writeable cursors with USE AGAIN, and occasionally without NOFILTER some very peculiar result sets show up in grids...I've removed all my Deleted indexes in the past week, and my SQL into cursors are running at least as fast as they were, with less CDX overhead...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.