>Your FAQ does a nice job of covering the various issues in some detail.
>
>I don't think that you've read my post, though, in the spirit in which its intended.
>
>First, I would always put a filter on a join condition as these are generally the most discriminating fields. I can see an exception for some lookup tables with low discrimination.
>
>Secondly, I was trying to provide some guidelines for experimentation. I know that there are situations in which low discriminating expressions, including on deleted, do offer a performance benefit. It really is up to the VFP developer to have general guidelines to tailor to their specific case.
Yes, I am aware that the index on deleted() (and other indices with low discrimination) may help, in some cases. But I did want to point out that it often doesn't: many people tend to think (as I did, some years ago), that "the more indices, the better". And Denise states that she doesn't have much experience with SQL - SELECT.
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)