>It's strange though because I went on a course about 4 years ago when it was just VFP 6. This course was Microsoft approved and the guy who taught us (who had a VFP MCP) told us that we must always set up an index on Deleted to improve performance. Basically I have always followed this advice.
Basically, if the index exists, the query might become Rushmore Optimizable;whereas without it, it won't. Now, this can cause confusion to some people. For Rushmore Optimizable doesn't necessarily mean it is optimal! The idea is that VFP uses any index that will match the search expression,
without considering whether doing so will likely make the query slower or faster. So, the expression is "Rushmore Optimizable", everyone is happy, until you find out, in some cases, that things are slower than with a "non-optimized" expression.
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)