sys.dm_pdw_nodes_exec_text_query_plan (Transact-SQL)

Returns the Showplan in text format for a Transact-SQL batch or for a specific statement within the batch.

Note

This syntax is not supported by serverless SQL pool in Azure Synapse Analytics.

Table returned

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 Transact-SQL 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 Transact-SQL statements, stored procedure calls, and user-defined function calls. Column is nullable.

Require sysadmin server role or VIEW SERVER STATE permission on the server.