Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Performance re-index before/after defragmentation?
Message
 
 
To
02/02/2003 11:46:13
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00748158
Message ID:
00748180
Views:
21
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform