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.
[Table(Schema = "sys", Name = "pdw_nodes_indexes", IsView = true)]
public class AzureSynapseAnalyticsSchema.NodesIndex- Inheritance
-
AzureSynapseAnalyticsSchema.NodesIndex
- Extension Methods
Properties
AllowPageLocks
1 = Index allows page locks.
Range: Always 1.
[Column("allow_page_locks")]
[NotNull]
public bool AllowPageLocks { get; set; }Property Value
AllowRowLocks
1 = Index allows row locks.
Range: Always 1.
[Column("allow_row_locks")]
[NotNull]
public bool AllowRowLocks { get; set; }Property Value
DataSpaceID
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
FillFactor
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
FilterDefinition
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
HasFilter
0 = Index does not have a filter.
Range: Always 0.
[Column("has_filter")]
[NotNull]
public bool HasFilter { get; set; }Property Value
IgnoreDupKey
0 = IGNORE_DUP_KEY is OFF.
Range: Always 0.
[Column("ignore_dup_key")]
[NotNull]
public bool IgnoreDupKey { get; set; }Property Value
IndexID
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
IsDisabled
1 = Index is disabled.
0 = Index is not disabled.
[Column("is_disabled")]
[NotNull]
public bool IsDisabled { get; set; }Property Value
IsHypothetical
0 = Index is not hypothetical.
Range: Always 0.
[Column("is_hypothetical")]
[NotNull]
public bool IsHypothetical { get; set; }Property Value
IsPadded
0 = PADINDEX is OFF.
Range: Always 0.
[Column("is_padded")]
[NotNull]
public bool IsPadded { get; set; }Property Value
IsPrimaryKey
1 = Index is part of a PRIMARY KEY constraint.
Range: Always 0.
[Column("is_primary_key")]
[NotNull]
public bool IsPrimaryKey { get; set; }Property Value
IsUnique
0 = Index is not unique.
Range: Always 0.
[Column("is_unique")]
[NotNull]
public bool IsUnique { get; set; }Property Value
IsUniqueConstraint
1 = Index is part of a UNIQUE constraint.
Range: Always 0.
[Column("is_unique_constraint")]
[NotNull]
public bool IsUniqueConstraint { get; set; }Property Value
Name
Name of the index. Name is unique only within the object. NULL = Heap
[Column("name")]
[NotNull]
public string Name { get; set; }Property Value
Object
objects (sys.objects)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = false)]
public ObjectSchema.Object Object { get; set; }Property Value
ObjectID
id of the object to which this index belongs.
[Column("object_id")]
[NotNull]
public int ObjectID { get; set; }Property Value
PdwNodeID
Unique identifier of a Azure Synapse Analytics node.
Range: NOT NULL
[Column("pdw_node_id")]
[NotNull]
public int PdwNodeID { get; set; }Property Value
TypeColumn
Type of index:
0 = Heap
1 = Clustered
2 = Nonclustered
5 = Clustered xVelocity memory optimized columnstore index
[Column("type")]
[NotNull]
public byte TypeColumn { get; set; }Property Value
TypeDesc
Description of index type:
HEAP
CLUSTERED
NONCLUSTERED
CLUSTERED COLUMNSTORE
[Column("type_desc")]
[NotNull]
public string TypeDesc { get; set; }