Applies To: SQL Server 2014, SQL Server 2016 Preview
Contains a row for each dictionary used in xVelocity memory optimized columnstore indexes. Dictionaries are used to encode some, but not all data types, therefore not all columns in a columnstore index have dictionaries. A dictionary can exist as a primary dictionary (for all segments) and possibly for other secondary dictionaries used for a subset of the column's segments.
Applies to: SQL Server (SQL Server 2012 through current version).
ID of the heap or B-tree index (hobt) for the table that has this columnstore index.
ID of the columnstore column.
Id of the dictionary.
Version of the dictionary format.
1 – Hash dictionary containing int values
2 – Not used
3 – Hash dictionary containing string values
4 – Hash dictionary containing float values
For more information about dictionaries, see Columnstore Indexes Guide.
The last data id in the dictionary.
Number of entries in the dictionary.
Size of dictionary in bytes.
Indicates the partition ID. Is unique within a database.
All columns require at least VIEW DEFINITION permission on the table. The following columns return null unless the user also has SELECT permission: last_id, entry_count, data_ptr.
The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.