Microsoft Exam Questions

Which statement should you use?

You need to capture the execution plan for a query. Which statement should you use?

A.
SET FORCEPLAN ON;

B.
SET SHOWPLAN_XML ON;

C.
SET STATISTICS IO ON;

D.
SET STATISTICS TIME ON;