Share via

Could database with compat level 100 support columnstore index?

RaufDBA 21 Reputation points
2020-11-05T08:58:29.187+00:00

Hi everyone. I asked this question previously on other forums, but didn't get satisfied answer. I hope I could find the answer here. So, I have an instance which runs on SQL Server 2017 Developer Edition instance. I restored database ContosoRetailDW which had compatibility level 100. After restore operation, I run the following query:

CREATE CLUSTERED COLUMNSTORE INDEX CCI_FactOnlineSales ON dbo.FactOnlineSales

The columnstore index was successfully created.

My question is related to the compat level. As far as I know, the columnstore index concept itself was came out in SQL Server 2012. Moreover, the clustered columnstore index was released in SQL Server 2014. How come database with compat level 100 support clustered columnstore index? It seems that database still inherits features of the current instance

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,669 questions
0 comments
Accepted answer
  1. tibor_karaszi@hotmail.com 4,311 Reputation points
    2020-11-05T10:32:08.21+00:00

    I've added a detailed explanation for this at your Stack Exchange post: https://dba.stackexchange.com/questions/279205/could-database-with-compat-level-100-support-columnstore-index

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.