Search code examples
sqlsql-serversql-server-2012columnstore

Does order of the columns in columnstore index matters in SQL Server 2012

I have a table with ~200 million rows and ~15 columns in it. I am planning to create the column store index on my table. Will there be any change in performance based on the order of columns that I use in the column store index? If Yes, what is the logic behind it?

Solution

  • No, it doesn't make any difference.