Sql-server – Can a table have Both a Clustered Columnstore Index and Nonclustered Columnstore Index

columnstoreindexperformanceperformance-tuningsql serversql-server-2016

Can I a table have both Clustered Columnstore Index and Nonclustered Columnstore Index?

I am seeing example strategies to use Clustered Columnstore Indexes with only Nonclustered Binary row indexes.

When I try creating both a Clustered Columnstore and Nonclustered Columnstore
I receive error:

Msg 35339, Level 16, State 1, Line 7
Multiple columnstore indexes are not supported.

Best Answer

No, you can't:

CREATE TABLE dbo.cs_test (id INT NOT NULL)

CREATE CLUSTERED COLUMNSTORE INDEX cs_whatever ON dbo.cs_test

CREATE NONCLUSTERED COLUMNSTORE INDEX nc_whatever ON dbo.cs_test(id);

Returns the error message:

Msg 35339, Level 16, State 1, Line 7 Multiple columnstore indexes are not supported.

The same result for multiple nonclustered columnstore indexes, as well.

Related Question