Open the context
Choose the project folder and name the files or behavior involved.
Workflows
Coding workflows · SQL query plans
03
A concrete starting point
Inspect a SQL query plan with data representative of the task. Compare row estimates and access paths, and verify the query result before attributing improvement to an index.
Define the change
Describe the input, expected output and boundaries that must stay intact.
Inspect the work
Review the proposed edits and any commands before relying on their result.
Check the outcome
Compare actual behavior with the expected result. If a check fails, investigate it before applying more changes.
SQL query plans
A concrete starting point
EXPLAIN
SELECT id, title
FROM entries
WHERE category = 'example'
ORDER BY created_at;The example is a starting point for a real project, not a claim that generated code is already tested. Adjust paths, dependencies and expected behavior to match your application.
