Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is it reasonable to have index on DELETED()?
Message
De
15/03/1999 22:52:52
 
 
À
14/03/1999 14:54:35
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00196021
Message ID:
00197913
Vues:
32
Hello Andrus,
If you have a large table and you SET DELETED ON, then you need the index on DELETED() regardless of how many records are deleted. If you do not have an index on DELETED(), VFP has to inspect each record to determine whether or not to present it. Thus, you lose all Rushmore optimization.
Regards, Chaim
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform