Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Performance re-index before/after defragmentation?
Message
 
À
02/02/2003 13:00:43
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
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:
00748233
Vues:
26
>>>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%.
>
>How would this affect the case - the usual case, I believe - where there are several indices, on differente fields or expressions?

I haven't yet tested to see. However, I would think that at least some reduction in size would occur simply because the main index would take up less size.
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