You can now create nonclustered indexes on the Clustered Columnstore index

This post is to correct a mistake I made in my previous post on Updateable Non Clustered Columnstore index in SQL 2016; in that post I mentioned that Clustered Columnstore index doesn’t allow other indexes to be create on the table. This is true and false.

Let me explain.

If your using SSMS to create the index then you will see the below screen and message

However if you use the T-SQL Command you can still create the index on the table as shown below. In this case I guess it’s just SSMS that’s not updated.

I have raised a connect for this at the below link

https://connect.microsoft.com/SQLServer/Feedback/Details/1552617

How to achieve something similar in SQL 2014

http://www.brentozar.com/archive/2014/03/add-nonclustered-indexes-clustered-columnstore-indexes/