Developing SQL Databases — Question 151

You have multiple queries that take a long time to complete.
You need to identify the cause by using detailed information about the Transact-SQL statements in the queries. The Transact-SQL statements must not run as part of the analysis.
Which Transact-SQL statement should you run?

Answer options

• A. SET STATISTICS IO ON
• B. SET SHOWPLAN_TEXT ON
• C. SET STATISTICS XML ON
• D. SET STATISTICS PROFILE ON

Correct answer: B

Explanation

The correct answer is B, as SET SHOWPLAN_TEXT ON provides a textual representation of the execution plan for the queries without actually running them. Options A, C, and D all involve running the queries or collecting execution statistics, which is not required for the analysis in this scenario.