Multiple choice technology web technology

What is true about COST column in the Explain Plan output?

  1. COST is SUBJECTIVE

  2. COST is RELATIVE

  3. COST is OBJECTIVE

  4. COST is SELECTIVE
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The COST column in Oracle's execution plan represents an internal unitless metric calculated by the optimizer. It is relative: it compares different execution paths for the same query but has no meaning across different queries or statements.

Keep practicing — related questions