Unique Clustered Columnstore Index

  • Comments posted to this topic are about the item Unique Clustered Columnstore Index

  • 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)

You must be logged in to reply to this topic. Login to reply