Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Best reindex practice
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00771255
Message ID:
00771259
Vues:
8
You've good reindexing procedure in place. I don't see any reason to change it.

>Hi All.
>Till now i reindexed by taking the following steps:
>Delete Tag All
>Pack
>Recreate indexes.
>
>Today i've read Jim Nelson's comments about the PACK command:
>"The Hacker's Guide is also simply wrong when it asserts that REINDEX does not remove "bloat". It does remove bloat of both kinds and has done so for several releases now. And a PACK that does an internal REINDEX does write to a new CDX file (as does REINDEX itself)."
>
>So does it mean that one PACK will be enough to both properly reindex and pack a table?
>What would you suggest be a good reindexing procedure?
>Best wishes.
>Kamil
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform