Stabilize query plan index choice
Medium SQL arena: index selectivity, WHERE clauses, and explain-plan reasoning
Log in and clear the lower tiers to unlock this mission.
Missing prerequisites: sql-easy-query-plan-index
A dashboard query regressed after data growth and the team needs a safer index proposal. You are working inside an analytics warehouse, and the arena only clears when the result is safe, deterministic, and explainable.
Learn to apply index selectivity, WHERE clauses, and explain-plan reasoning in an analytics warehouse while explaining the invariant, safety constraints, and hidden edge cases.
- Demonstrates index selectivity, WHERE clauses, and explain-plan reasoning
- Handles the visible sample and hidden edge cases
- Keeps output deterministic and explainable
- Stays read-only
Clear the route first
You can read the mission brief, but the editor, hints, tests, and submit flow stay locked until progression or plan access catches up.
Test Results
Run the visible checks when your first pass is ready.
Clear Protocol
Rewards
Mission Route
Hints
Hints are metered and logged for No Hint Hero runs.
Genie Mentor Core
Hint protocol / contextual guardrails active