I am just about to start on an excercise to reorganise a partitioned table and I was looking for best practises or recommendations.
Let us say I have a billion row table and 8 logical disks available to me for this table.
The question I have is, is it better to create a partition scheme which divides the data into 8 filegroups and has the indexes storage aligned with the data...
Or would it be better to create 4 file groups for data and 4 for indexes (not aligned), then place each of the filegroups onto one logical disk?
Any suggestion or comments would be welcome.