Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Performance re-index before/after defragmentation?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00748158
Message ID:
00748187
Vues:
30
>Has any solid research been done in reference to performance after re-indexing before verses after defragmentation of the drive?

In addition to degragmentation, you should also consider re-ordering the table to its "natural" order. For example, if you have a table that's ordered by one particular field, re-building that table so that the records are in that order can yield a reduction of index size of up to 20%.
George

Ubi caritas et amor, deus ibi est
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform