Parallel clustered columnstore index build

128 Views Asked by At

Is it possible to build clustered columnstore index using several processes and keeping the row order of clustered rowstore index? Table is partitioned. Currently I am converting rowstore index to columnstore like this:

CREATE CLUSTERED columnstore INDEX [index_name] ON schema.table
    WITH (
            drop_existing = ON
            ,MAXDOP = 1
            )

If I increase MAXDOP, then row order isn't kept. I am thinking about creating separate table for every partition and then doing partition switching. Maybe there is a better way?

0

There are 0 best solutions below