SET SHOWPLAN_TEXT¶
Causes engine not to execute Transact-SQL statements. Instead, a detailed information about how the statements executed is returned that provides estimates of the resource requirements for the statements.
Syntax¶
SET SHOWPLAN_TEXT { ON | OFF } [;]
Remarks¶
Argument values are ignored and do not change the default behavior.
Permissions¶
Requires membership in the public role.