Hi gerry,
>>This is really a bad advice. The INDEX ON DELETED() should never be used except for very specific cases. If you index a million record table this way, and try to open this table through a slow network, it might take ages to open the table since rushmore has to load about the whole indextag to find the first non deleted record in the table. This is one of the most nasty pitfalls of the INDEX ON DETELED() tag.
>
>A DELETED() index is not a problem if you include the filter FOR DELETED() when creating the index.
Unless the VFP team decides to make filtered indexes optimizable in VFP 9 as I did request in the wishlist. Actually I did propose the use of INDEX ON .T. FOR DELETED() in
Re: Should I add DELETED() tag Thread #
507170 Message #
508207 about two years ago now.
Walter,