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

Click here to load this message in the networking platform