Can someone explain to me the reason a clustered index is required on Sql Server tables when moving them to another file group.
A table without a clustered index is stored as a heap where as adding a clustered index would change it to a B-Tree. Both heap and B Tree are tree-based data structures differing in the fact that B Tree is ordered. Why would this influence a table's file group changes?
Asking more out of curiosity rather than facing a active problem..Thanks