A practical SQL query tuning playbook: execution plans, joins, indexes, and the traps
How I approach SQL tuning end to end — reading execution plans, the cost model, query rewrites, index strategy, the three join algorithms, the implicit-cast trap, and when a subquery beats a JOIN.