Επεξεργασία

Κοινή χρήση μέσω

sys.pdw_nodes_indexes (Transact-SQL)

  • Άρθρο

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

Returns indexes for Azure Synapse Analytics.

Column Name Data Type Description Range
object_id int id of the object to which this index belongs.
name sysname Name of the index. Name is unique only within the object. NULL = Heap
index_id int id of the index. index_id is unique only within the object.

0 = Heap

1 = Clustered index

> 1 = Nonclustered index
type tinyint Type of index:

0 = Heap

1 = Clustered

2 = Nonclustered

5 = Clustered xVelocity memory optimized columnstore index
type_desc nvarchar(60) Description of index type:

HEAP

CLUSTERED

NONCLUSTERED

CLUSTERED COLUMNSTORE
is_unique bit 0 = Index is not unique. Always 0.
data_space_id 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.
ignore_dup_key bit 0 = IGNORE_DUP_KEY is OFF. Always 0.
is_primary_key bit 1 = Index is part of a PRIMARY KEY constraint. Always 0.
is_unique_constraint bit 1 = Index is part of a UNIQUE constraint. Always 0.
fill_factor tinyint > 0 = FILLFACTOR percentage used when the index was created or rebuilt.

0 = Default value		 Always 0.
is_padded bit 0 = PADINDEX is OFF. Always 0.
is_disabled bit 1 = Index is disabled.

0 = Index is not disabled.
is_hypothetical bit 0 = Index is not hypothetical. Always 0.
allow_row_locks bit 1 = Index allows row locks. Always 1.
allow_page_locks bit 1 = Index allows page locks. Always 1.
has_filter bit 0 = Index does not have a filter. Always 0.
filter_definition nvarchar(max) Expression for the subset of rows included in the filtered index. Always NULL.
pdw_node_id int Unique identifier of a Azure Synapse Analytics node. NOT NULL

Permissions

Requires CONTROL SERVER permission.

See Also

Azure Synapse Analytics and Parallel Data Warehouse Catalog Views