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