I have a table with 7 columns. The user could want any of these columns for the query. So I am going to create a columnstore index for all 7 columns. Is this a sound plan? Or is there some problem with creating for all columns?
Ok I just used all columns. This is actually a silly question because of course u should put all columns if they are being used.