July 10, 2020 at 12:00 am
Comments posted to this topic are about the item Unique Clustered Columnstore Index
July 10, 2020 at 5:56 am
Interesting question, thanks Steve.
Have never really thought about that before, i've only ever used columnstore indexes on regular numeric columns...
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
July 10, 2020 at 10:09 am
Yes, it is not possible. But you can combine a clustered columnstore index with a nonclustered unique rowstore index or a nonclustered 'primary key'-index (an index create by specifying PRIMARY KEY).
July 13, 2020 at 6:42 am
Got to know something new today, though was confusing to me initially.
One can create Clustered & Non-Clustered ColumnStore Index but you can NOT add any constraints to it! Quoting from Microsoft website --> Constraints are always enforced with a row-store index. Constraints cannot be enforced with a columnstore (clustered or nonclustered) index.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply