What should you use to display the query execution plan in Microsoft SQL Server Management Studio (SSMS)?

Posted by: Pdfprep Category: DP-300 Tags: , ,

You have an Azure SQL database.

You identify a long running query.

You need to identify which operation in the query is causing the performance issue.

What should you use to display the query execution plan in Microsoft SQL Server Management Studio (SSMS)?
A . Live Query Statistics
B . an estimated execution plan
C . an actual execution plan
D . Client Statistics

Answer: C

Explanation:

To include an execution plan for a query during execution

Leave a Reply

Your email address will not be published.