The ____ command is used to examine potential query plans that the optimizer may utilize,when executing a particular query of DML statement.
A) TKPROF
B) EXPLAIN PLAN
C) OPTIMIZE
D) STATSPACK

Question

Quizplus · Accepted Answer

The EXPLAIN PLAN command is used to display the execution plan that the optimizer has chosen for a SQL statement. It can be used to analyze the steps the database will take to execute a query and help identify potential performance issues. TKPROF is a utility for analyzing SQL trace files generated by the Oracle Trace facility. OPTIMIZE and STATSPACK are not commands for examining query plans.

The ____ Command Is Used to Examine Potential Query Plans