Programming and Development
Diagnose a slow SQL query from its execution plan and propose rewrites and indexes, with an explanation of why they help and what they cost.