I am partitioning a table by date (month). The server has four drives. The partition scheme is defined as
CREATE PARTITION SCHEME ByDate AS PARTITION ByDate TO (
[PRIMARY], [fg2], [fg3], [fg4],
[PRIMARY], [fg2], [fg3], [fg4],
[PRIMARY], [fg2], [fg3], [fg4],
......
Which of following option is better?
- Create one file for each file group
[PRIMARY], [fg2], [fg3], [fg4]
. And put each file in different drive. - Create four files for each file group. And save each files in different drive.