Posted by Stu on 11/30/05 14:00

Where your clustered index is, your table is. When you move a
clustered index to a new filegroup, you are moving the entire table to
that filegroup, so there is no performance gain in moving the index
(unless you're moving to better hardware or a better configuration).

Just to be clear, in order to get a performance boost using filegroups,
those filegroups must be on seperate physical disk structures; however,
when you move a clustered index, you're moving the whole table.

HTH,
Stu

[Back to original message]