PrepAway - Latest Free Exam Questions & Answers

how would you obtain the query execution plan?

Given a plan ID, how would you obtain the query execution plan? (Choose two.)

PrepAway - Latest Free Exam Questions & Answers

A.
“Turn ODBC tracing ON.

B.
“Issue “SELECT * FROM _V_SESSION;”

C.
“Go to the query history within the Windows NzAdmin GUI tool.

D.
“Run EXECUTION PLAN before the query has been submitted.

E.
“Issue “SHOW PLANFILE <nn>;” after the query has been submitted.

Explanation:


Leave a Reply