August 15, 2019 at 1:52 am
I have a table that has Clustered PK Index and a non-unique Clustered index
Our vendor wants to add a non clustered Columnstore index to the table aswell.
I was under the impression in SQL 2016 you can only have the one clustered columnstore and not have all three types 1, 2 and 5
Any thoughts ?
https://sqlworkbooks.com/2017/05/batch-mode-hacks-for-rowstore-queries-in-sql-server/
August 15, 2019 at 5:01 pm
I have a table that has Clustered PK Index and a non-unique Clustered index
That's not possible. You cannot have 2 clustered indexes on a table. If the PK is clustered, then the non-unique index cannot be clustered, and the same is true in the reverse.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply