>>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?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
