sys.pdw_index_mappings (Transact-SQL)
Applies to:
Azure Synapse Analytics
Analytics Platform System (PDW)
Maps the logical indexes to the physical name used on Compute nodes as reflected by a unique combination of object_id of the table holding the index and the index_id of a particular index within that table.
Column Name | Data Type | Description | Range |
---|---|---|---|
object_id | int | The object ID for the logical table on which this index exists. See sys.objects (Transact-SQL). physical_name and object_id form the key for this view. |
|
index_id | nvarchar(32) | The ID for the index. See sys.indexes (Transact-SQL). | |
physical_name | nvarchar(36) | The name of the index in the databases on the Compute nodes. physical_name and object_id form the key for this view. |
See Also
Azure Synapse Analytics and Parallel Data Warehouse Catalog Views
sys.pdw_table_mappings (Transact-SQL)
sys.pdw_permanent_table_mappings (Transact-SQL)
sys.pdw_database_mappings (Transact-SQL)
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru