>>>>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.
Yes, that makes sense.
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)