| title | sys.dm_pdw_nodes_exec_text_query_plan (Transact-SQL) | |
|---|---|---|
| description | Dynamic management view that returns the Showplan in text format for a Transact-SQL batch or for a specific statement within the batch. | |
| author | jacinda-eng | |
| ms.author | jacindaeng | |
| ms.reviewer | wiassaf | |
| ms.date | 10/14/2019 | |
| ms.service | sql | |
| ms.subservice | data-warehouse | |
| ms.topic | reference | |
| dev_langs |
|
|
| monikerRange | =azure-sqldw-latest |
[!INCLUDE asa]
Returns the Showplan in text format for a [!INCLUDEtsql] batch or for a specific statement within the batch.
Note
[!INCLUDEsynapse-analytics-od-unsupported-syntax]
| Column name | Data type | Description |
|---|---|---|
| pdw_node_ID | int | Unique numeric ID associated with the node. |
| dbid | smallint | ID of the context database that was in effect when the [!INCLUDEtsql] statement corresponding to this plan was compiled. For ad hoc and prepared SQL statements, the ID of the database where the statements were compiled. Column is nullable. |
| objectid | int | ID of the object (for example, stored procedure or user-defined function) for this query plan. For ad hoc and prepared batches, this column is null. Column is nullable. |
| number | smallint | Numbered stored procedure integer. For ad hoc and prepared batches, this column is null. Column is nullable. |
| encrypted | bit | Indicates whether the corresponding stored procedure is encrypted. 0 = not encrypted 1 = encrypted Column is not nullable. |
| query_plan | nvarchar(max) | Contains the compile-time Showplan representation of the query execution plan that is specified with plan_handle. The Showplan is in text format. One plan is generated for each batch that contains, for example ad hoc [!INCLUDEtsql] statements, stored procedure calls, and user-defined function calls. Column is nullable. |
The same remarks in sys.dm_exec_text_query_plan apply.
Require sysadmin server role or VIEW SERVER STATE permission on the server.
Azure Synapse Analytics and Parallel Data Warehouse Dynamic Management Views (Transact-SQL)
For more development tips, see Azure Synapse Analytics development overview.