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

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

View Answer

Answer: A

Explanation:

https://www.mssqltips.com/sqlservertip/3685/live-query-statistics-in-sql-server-2016/