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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy