Consulting
SQL performance review
We study the queries that hurt — not every SELECT in the repo — and show which changes buy the most headroom.
You provide up to twenty-five query texts with typical bind parameters, plus one week of performance statistics if available. We reproduce plans in a sanitised staging clone or read-only replica when you grant access.
Deliverables
- Per-query notes: plan operators, row estimates, suggested indexes or rewrites
- Summary ranking by expected latency reduction and implementation effort
- Optional pairing session while your DBA applies the first two changes
Duration
Seven business days standard. Suitable for monthly batch jobs, API hot paths, and BI extracts that share the same warehouse.
Pricing is per review bundle on the rates page. Combine with a schema design review when model issues and query shape problems overlap.