Can clustered columnstore indexes co-exist with non-clusered indexes?

• smitty-1088185

  SSCrazy

  Points: 2321

  More actions

  July 1, 2018 at 9:14 am

  #371284

  I'm studying for exam 70-764 and the question asked if you could have more than one index on a table that has a clustered column store index on it.
  So the answer in the book says you cannot have any other indexes on a  tables with clustered columnstore index but I tried it myself and I was able
  to create a non-clustered index. Did something change recently?

• Evgeny Garaev

  SSCertifiable

  Points: 7428

  More actions

  July 3, 2018 at 3:58 pm

  #1996235

  That depend on the version of MS SQL Server.
  https://docs.microsoft.com/en-us/sql/t-sql/statements/create-columnstore-index-transact-sql?view=sql-server-2017