Question
EXPLAIN PLAN versus an executed cursor plan: which evidence should guide tuning?
Answer
EXPLAIN PLAN is an optimizer prediction without execution. An executed cursor plan can expose actual rows, starts, and runtime behavior. Use the executed cursor plan for a live regression; use EXPLAIN PLAN for safe hypothetical checks.