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

Inherited Members

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Extension Methods

Map.DeepCopy<T>(T)

Properties

ColumnID

column_id NOT NULL int

ID of the columnstore column.

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

Property Value

int

DictionaryID

dictionary_id NOT NULL int

Id of the dictionary.

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

Property Value

int

EntryCount

entry_count NOT NULL bigint

Number of entries in the dictionary.

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

Property Value

long

HoBTID

hobt_id NOT NULL bigint

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

last_id NOT NULL int

The last data id in the dictionary.

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

Property Value

int

OnDiskSize

on_disk_size NOT NULL bigint

Size of dictionary in bytes.

[Column("on_disk_size")]
[NotNull]
public long OnDiskSize { get; set; }

Property Value

long

PartitionID

partition_id NOT NULL bigint

Indicates the partition ID. Is unique within a database.

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

Property Value

long

PdwNodeID

pdw_node_id NOT NULL int

Unique identifier of a Azure Synapse Analytics node.

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

Property Value

int

Type

type NOT NULL int

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 Type { get; set; }

Property Value

int

Version

version NOT NULL int

Version of the dictionary format.

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

Property Value

int