is Clustered Columnstore index UNIQUE by default?

• Vladimir Isaev

  Hall of Fame

  Points: 3846

  More actions

  July 6, 2020 at 12:42 am

  #3767589

  Or should I explicitly specify 'CREATE UNIQUE CLUSTERED COLUMNSTORE INDEX....' ?

  If I don't specify UNIQUE,  can a clustered index actually be non-unique..??

  Likes to play CHESS

• Jeff Moden

  SSC Guru

  Points: 1000363

  More actions

  July 6, 2020 at 1:11 am

  #3767594

  Such an easy thing for you to try to find out. 😉

   

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
  "Change is inevitable... change for the better is not".
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  Intro to Tally Tables and Functions

• Steve Jones - SSC Editor

  SSC Guru

  Points: 727916

  More actions

  July 6, 2020 at 2:19 pm

  #3767715

  https://docs.microsoft.com/en-us/sql/t-sql/statements/create-columnstore-index-transact-sql?view=sql-server-ver15

  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