Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index on deleted()
Message
De
02/04/2001 02:48:22
Walter Meester
HoogkarspelPays-Bas
 
 
À
31/03/2001 21:08:15
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00490398
Message ID:
00490841
Vues:
11
Glenn,

>The seek mentioned is to access the primary key which, when the record is deleted, is inverted. No additional indexes are required to support this method. It is not necessary to index on deleted to locate deleted records. With this technique only the primary index is needed therefore no extra overhead is experienced.
>
>The number of deleted records is minimized, file sizes can stabilize (depending on the application) and tables do not require packing or reindexing as often.

I agree... This can also be a suitable solution to recycle records.

Walter,
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform