Oracle 26ai · SQL Tuning · Module 8

Module 8

Cost-Based Planning: Exercise

Objective: Explain cost-based planning without applying historical table-order rules.

Tasks

  1. Arrange these conceptual stages: evaluate a representative execution; validate SQL; compare candidates and select a plan; consider transformations and estimate work. Explain that this is a teaching sequence, not a complete internal trace, and that an existing cursor may be reused.
  2. Correct this statement: “The first FROM table must drive the query, and the lowest cost proves the fastest measured execution.”

Self-assessment: 10 points

Award 5 points for the conceptual sequence, 3 for correcting the FROM-order claim, and 2 for explaining why estimated cost is not a benchmark. No automatic grading is performed.

Your answer is not stored or sent to a tutor. It is displayed safely on the result page. SQL is not executed.