Step 6: Consider Plan History

Plans can change. To see what changed and when:

SELECT *
FROM dba_hist_sql_plan
WHERE sql_id = '<your-sql-id>'
ORDER BY plan_hash_value, timestamp;

Look for:

  • Plan changes over time
  • Elapsed time or row differences across plans