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