A command used in Oracle to display how the query optimizer intends to access indexes, use parallel servers, and join tables to prepare query results is the:
A) explain plan.
B) show optimization.
C) explain query.
D) analyze query.

Question

Quizplus · Accepted Answer

The "EXPLAIN PLAN" command in Oracle is used to display the execution plan of a SQL query, showing how the query optimizer intends to access indexes, use parallel servers, and join tables.

A Command Used in Oracle to Display How the Query