Posted by Stu on 11/30/05 13:11

Hey Danny,

In both cases your data will physically reside in the space where there
is either a clustered index OR (in the case of a heap) on the drive
where the table was created. What you didn't ask about was
nonclustered indexes; if you move the clustered index, the nonclustered
indexes will stay where they are. If the filegroups are one seperate
disk structures, you may see some disk i/o benefits.

Does that help?

Stu

[Back to original message]