Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Performance re-index before/after defragmentation?
Message
 
 
À
02/02/2003 11:46:13
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:
00748180
Vues:
22
Jim,
>
>2) REINDEX (except in VFP7SP1) will remove CDX "bloat" of both the deleted TAG variety and the 'random inserts causing extra nodes' variety. A smaller file is always better and I should think especially so where it is a .CDX. A REINDEX will also result in a 'contiguous' (as much as available RAM will allow) .CDX file as its output.
>

You're confusing index size with index bloat. REINDEX command in any version of VFP will remove index bloat.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform