>I recall there being an article in FoxPro Advisor not too long ago about the pros and cons of creating an index on DELETED(). Anybody rememeber was issue it was???
The article mentioned only cons.
I discussed this topic in FAQ#8109.
In summary, you should usually NOT use an index on DELETED(), since this will result in Full Rushmore Optimization.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)