I created a Table with partitions (on the date column) of a table with a clustered column store index.
I am able to run Index Rebuilds on each partition as needed, which is definitely faster than rebuilding the whole index.
All the partitions are in the default PRIMARY file group, and hold a month's data.
Issue:
When I run index rebuild on 2 partitions at the same time, it runs the commands in sequence, instead of simultaneously. Even if they are triggered in different sessions, one command will be blocked till the other one is finished. (MAXDOP = 8 , did not change this behaviour)
Do I have to put each partition in a different file? (create a new file group for this table), in order to rebuild these partitions at the same time?
I tried using MAXDOP = 8 (We have 8 CPUs), I tried running the Two index rebuild commands (which were for different partitions of the same table) in 2 different sessions.
I expected both partitions to be rebuilt at the same time as the rebuild command is affecting only a particular section of the table, and would not block other partitions from being rebuilt