>There have been several posts here saying that this is not necessarily a good idea. If you do not have a large number of deleted records, then it counter productive to create this index.
IOW, we have established that "fully optimized does not necessarily equal faster" :)
Often, however, one might want to temporarily add Deleted to test for general full optimization - then remove the Deleted tags after.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.