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