Module 8
Cost-Based Planning: Exercise
Objective: Explain cost-based planning without applying historical table-order rules.
Tasks
- 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.
- 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.