Diagnose slow queries from execution plans, find missing indexes and N-plus-one patterns, and prescribe targeted optimizations.
## CONTEXT A slow application is frequently a slow database underneath, and the database tells you exactly why if you read the execution plan. The plan reveals whether the engine scanned a whole table, used the right index, estimated row counts accurately, and where time was actually spent. Common pathologies include…
Premium Prompt
Unlock this prompt — and all 25,000+ expert-crafted prompts — with Pro.
Unlock with Pro