Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Does index tag on DELETED() help?
Message
De
06/11/2004 16:56:29
Jon Neale
Bond International Software
Wootton Bassett, Royaume Uni
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00958911
Message ID:
00958916
Vues:
23
This message has been marked as the solution to the initial question of the thread.
Hi Dmitry,

It can be used to help speed up queries.

I got this snipet from the Hackers guide to Visula Foxpro

If you choose to SET DELETED ON, every table should have an index tag with a key of DELETED(). Rushmore uses the tag to optimize elimination of deleted records. Otherwise, result sets have to be checked sequentially for records marked for deletion. It doesn't matter whether or not any records are actually deleted. Only the SET DELETED choice matters.


Jon
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform