Explanation:When SET SHOWPLAN_XML is ON, SQL Server returns execution plan information for each statement without executing it 3. ___________ displays the profile information for a statement.
A. SET STATISTICS
B. SET STATS PROFILE
C. SET STATISTICS PROFILE
D. All of the mentioned
Answer:A
Explanation:When SET SHOWPLAN_XML is ON, SQL Server returns execution plan information for each statement without executing it 3. ___________ displays the profile information for a statement.
A. SET STATISTICS B. SET STATS PROFILE C. SET STATISTICS PROFILE D. All of the mentioned
Explanation:STATISTICS PROFILE works for ad hoc queries, views, and stored procedures. 4. To produce execution plan output by using most Showplan Transact-SQL SET options, users must have