sys.column_store_dictionaries (Transact-SQL)
Contains a row for each column in an xVelocity memory optimized columnstore index.
|
Column name |
Data type |
Description |
|---|---|---|
|
hobt_id |
bigint |
ID of the heap or B-tree index (hobt) for the table that has this columnstore index. |
|
column_id |
int |
ID of the columnstore column. |
|
dictionary_id |
int |
Id of the dictionary. |
|
version |
int |
Version of the dictionary format. |
|
type |
int |
Dictionary type: 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. |
|
last_id |
int |
The last data id in the dictionary. |
|
entry_count |
bigint |
Number of entries in the dictionary. |
|
on_disc_size |
bigint |
Size of dictionary in bytes. |
|
partition_id |
bigint |
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.
