SQL Performance Surgery

A dashboard query ran in eighty milliseconds for a year, then one Monday it takes four seconds, and the first message in the team channel asks if you can just add an index. Sometimes yes. More often three hours get spent adding indexes, waiting, and settling on whatever change made the complaints stop, with nobody able to say why. This book is for developers who already know SQL and still feel los...