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?


No, the column order does not matter, also add all the columns you need to the Column Store Index for all your use cases as there can be only 1 column store index, it will not hurt the performance.

This video can help you solving your question :)
By: admin