Comments posted to this topic are about the item Unique Clustered Columnstore Index
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
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”
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).
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)