Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best reindex practice
Message
From
28/03/2003 08:24:42
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Best reindex practice
Miscellaneous
Thread ID:
00771255
Message ID:
00771255
Views:
38
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
A moment of silence is our cosmic reset button.
Next
Reply
Map
View

Click here to load this message in the networking platform