Class AzureSynapseAnalyticsSchema.NodesColumnStoreDictionary

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sys.pdw_nodes_column_store_dictionaries (Transact-SQL)

Applies to: √ Azure Synapse Analytics √ Analytics Platform System (PDW)

Contains a row for each dictionary used in 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.

See sys.pdw_nodes_column_store_dictionaries.

[Table(Schema = "sys", Name = "pdw_nodes_column_store_dictionaries", IsView = true)]
public class AzureSynapseAnalyticsSchema.NodesColumnStoreDictionary

Inheritance

object

AzureSynapseAnalyticsSchema.NodesColumnStoreDictionary

Extension Methods

Map.DeepCopy<T>(T)

Properties

ColumnID

ID of the columnstore column.

[Column("column_id")]
[NotNull]
public int ColumnID { get; set; }

Property Value

int

DictionaryID

Id of the dictionary.

[Column("dictionary_id")]
[NotNull]
public int DictionaryID { get; set; }

Property Value

int

EntryCount

Number of entries in the dictionary.

[Column("entry_count")]
[NotNull]
public long EntryCount { get; set; }

Property Value

long

HoBTID

ID of the heap or B-tree index (HoBT) for the table that has this columnstore index.

[Column("hobt_id")]
[NotNull]
public long HoBTID { get; set; }

Property Value

long

LastID

The last data id in the dictionary.

[Column("last_id")]
[NotNull]
public int LastID { get; set; }

Property Value

int

OnDiscSize

Size of dictionary in bytes.

[Column("on_disc_size")]
[NotNull]
public long OnDiscSize { get; set; }

Property Value

long

PartitionID

Indicates the partition ID. Is unique within a database.

[Column("partition_id")]
[NotNull]
public long PartitionID { get; set; }

Property Value

long

PdwNodeID

Unique identifier of a Azure Synapse Analytics node.

[Column("pdw_node_id")]
[NotNull]
public int PdwNodeID { get; set; }

Property Value

int

TypeColumn

Dictionary type:

1 - Hash dictionary containing int values

2 - Not used

3 - Hash dictionary containing string values

4 - Hash dictionary containing float values

[Column("type")]
[NotNull]
public int TypeColumn { get; set; }

Property Value

int

Version

Version of the dictionary format.

[Column("version")]
[NotNull]
public int Version { get; set; }

Property Value

int