Table of Contents

Class AzureSynapseAnalyticsSchema.NodesIndex

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.pdw_nodes_indexes (Transact-SQL)

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

Returns indexes for Azure Synapse Analytics.


See sys.pdw_nodes_indexes.

[Table(Schema = "sys", Name = "pdw_nodes_indexes", IsView = true)]
public class AzureSynapseAnalyticsSchema.NodesIndex
Inheritance
AzureSynapseAnalyticsSchema.NodesIndex
Inherited Members
Extension Methods

Properties

AllowPageLocks

allow_page_locks NOT NULL bit

1 = Index allows page locks.
Range: Always 1. 
[Column("allow_page_locks")]
[NotNull]
public bool AllowPageLocks { get; set; }

Property Value

bool

AllowRowLocks

allow_row_locks NOT NULL bit

1 = Index allows row locks.
Range: Always 1. 
[Column("allow_row_locks")]
[NotNull]
public bool AllowRowLocks { get; set; }

Property Value

bool

DataSpaceID

data_space_id NOT NULL int

id of the data space for this index. Data space is either a filegroup or partition scheme.

0 = object_id is a table-valued function. 
[Column("data_space_id")]
[NotNull]
public int DataSpaceID { get; set; }

Property Value

int

FillFactor

fill_factor NOT NULL tinyint

> 0 = FILLFACTOR percentage used when the index was created or rebuilt.

0 = Default value
Range: Always 0. 
[Column("fill_factor")]
[NotNull]
public byte FillFactor { get; set; }

Property Value

byte

FilterDefinition

filter_definition NOT NULL nvarchar(max)

Expression for the subset of rows included in the filtered index.
Range: Always NULL. 
[Column("filter_definition")]
[NotNull]
public string FilterDefinition { get; set; }

Property Value

string

HasFilter

has_filter NOT NULL bit

0 = Index does not have a filter.
Range: Always 0. 
[Column("has_filter")]
[NotNull]
public bool HasFilter { get; set; }

Property Value

bool

IgnoreDupKey

ignore_dup_key NOT NULL bit

0 = IGNORE_DUP_KEY is OFF.
Range: Always 0. 
[Column("ignore_dup_key")]
[NotNull]
public bool IgnoreDupKey { get; set; }

Property Value

bool

IndexID

index_id NOT NULL int

id of the index. index_id is unique only within the object.

0 = Heap

1 = Clustered index

> 1 = Nonclustered index 
[Column("index_id")]
[NotNull]
public int IndexID { get; set; }

Property Value

int

IsDisabled

is_disabled NOT NULL bit

1 = Index is disabled.

0 = Index is not disabled. 
[Column("is_disabled")]
[NotNull]
public bool IsDisabled { get; set; }

Property Value

bool

IsHypothetical

is_hypothetical NOT NULL bit

0 = Index is not hypothetical.
Range: Always 0. 
[Column("is_hypothetical")]
[NotNull]
public bool IsHypothetical { get; set; }

Property Value

bool

IsPadded

is_padded NOT NULL bit

0 = PADINDEX is OFF.
Range: Always 0. 
[Column("is_padded")]
[NotNull]
public bool IsPadded { get; set; }

Property Value

bool

IsPrimaryKey

is_primary_key NOT NULL bit

1 = Index is part of a PRIMARY KEY constraint.
Range: Always 0. 
[Column("is_primary_key")]
[NotNull]
public bool IsPrimaryKey { get; set; }

Property Value

bool

IsUnique

is_unique NOT NULL bit

0 = Index is not unique.
Range: Always 0. 
[Column("is_unique")]
[NotNull]
public bool IsUnique { get; set; }

Property Value

bool

IsUniqueConstraint

is_unique_constraint NOT NULL bit

1 = Index is part of a UNIQUE constraint.
Range: Always 0. 
[Column("is_unique_constraint")]
[NotNull]
public bool IsUniqueConstraint { get; set; }

Property Value

bool

Name

name NOT NULL sysname

Name of the index. Name is unique only within the object. NULL = Heap 
[Column("name")]
[NotNull]
public string Name { get; set; }

Property Value

string

Object

objects (sys.objects)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = false)]
public ObjectSchema.Object Object { get; set; }

Property Value

ObjectSchema.Object

ObjectID

object_id NOT NULL int

id of the object to which this index belongs. 
[Column("object_id")]
[NotNull]
public int ObjectID { get; set; }

Property Value

int

PdwNodeID

pdw_node_id NOT NULL int

Unique identifier of a Azure Synapse Analytics node.
Range: NOT NULL 
[Column("pdw_node_id")]
[NotNull]
public int PdwNodeID { get; set; }

Property Value

int

Type

type NOT NULL tinyint

Type of index:

0 = Heap

1 = Clustered

2 = Nonclustered

5 = Clustered xVelocity memory optimized columnstore index 
[Column("type")]
[NotNull]
public byte Type { get; set; }

Property Value

byte

TypeDesc

type_desc NOT NULL nvarchar(60)

Description of index type:

HEAP

CLUSTERED

NONCLUSTERED

CLUSTERED COLUMNSTORE 
[Column("type_desc")]
[NotNull]
public string TypeDesc { get; set; }

Property Value

string