Posted by Dr Warehouse on 11/30/05 12:17

Hi,

I am expanding our data warehouse solution with new filegroups on
several subsystems.

I want to know which idea is better!

- create clustered indexes on tables to 'move' them to new filegroups
- create these tables on the new filegroups.

The background of this question is as follows:

- we want the whole data on the new filegroups
- we want to know if there is any difference in performance between the
2 solutions

Thanks in advance,
Danny

[Back to original message]