What is the purpose of sys.column_store_dictionaries ?

 Posted by Niladri.Biswas on 4/26/2013 | Category: Sql Server Interview questions | Views: 3406 | Points: 40
Answer:

The sys.column_store_dictionaries catalog view is one of the new catalog views that supports columnstore indexes. This catalog view returns one row for each column in a columnstore index. The data describes the structure and type of dictionary built for the column.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response