>Hi all,
>
>The VFP 5.0 Developer's Guide states at page 396, parag. 5, " Avoid using indexes on fields that contain only a few discrete values such as a logical field"
>
>So then why should having an index based on deleted() be considered indexing effectively using Rushmore (see DG page 400)
>
>Aren't these two very similar in their respective context (i.e.: few discrete values .T. or .F.).
>
>Why should it be OK for deleted() and not for the other(s)?
>
>Thanks
>
>Pierre Richard
As a general rule, if your table will have mostly added data and modified data (very few deletes), the tag won't help. However if you will be deleting lots of data, a DELETED() tag will help. My experience is that the large majority of tables have very few deletes.
BTW, if you are trying to understand Rushmore, have you looked at the article on my website?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer