All the indexes

  • TRACEY-320982

    SSChampion

    Points: 13480

    I have a table that has Clustered PK Index and a non-unique Clustered index

    Our vendor wants to add a non clustered Columnstore index to the table aswell.

    I was under the impression in SQL 2016 you can only have the one clustered columnstore and not have all three types 1, 2 and 5

    Any thoughts  ?

    https://sqlworkbooks.com/2017/05/batch-mode-hacks-for-rowstore-queries-in-sql-server/

     

  • Michael L John

    One Orange Chip

    Points: 25713

    TRACEY-320982 wrote:

    I have a table that has Clustered PK Index and a non-unique Clustered index

     

    That's not possible.  You cannot have 2 clustered indexes on a table.  If the PK is clustered, then the non-unique index cannot be clustered, and the same is true in the reverse.

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

Viewing 2 posts - 1 through 2 (of 2 total)

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