| title | sys.pdw_nodes_indexes (Transact-SQL) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/04/2017 | |
| ms.prod | sql-non-specified | |
| ms.reviewer | ||
| ms.suite | ||
| ms.technology |
|
|
| ms.tgt_pltfrm | ||
| ms.topic | language-reference | |
| dev_langs |
|
|
| ms.assetid | 261bcb7f-a906-4979-b274-bc5f1aa66426 | |
| caps.latest.revision | 7 | |
| author | barbkess | |
| ms.author | barbkess | |
| manager | jhubbard |
[!INCLUDEtsql-appliesto-xxxxxx-xxxx-asdw-pdw_md]
Returns indexes for [!INCLUDEssSDW].
| 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 = Non-clustered index |
|
| type | tinyint | Type of index: 0 = Heap 1 = Clustered 2 = Non-clustered 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 [!INCLUDEssSDW] node. | NOT NULL |
Requires CONTROL SERVER permission.
SQL Data Warehouse and Parallel Data Warehouse Catalog Views