> I hate that someone can change my schema, and that can turn my efficient index lookup into a horrible scan, without breaking tests.

They can't, if you do perf testing as part of your pre-release testing, which you should do.

If you aren't doing perf testing, you are saying perf isn't an acceptance criteria, so why are you upset that breaking perf doesn't break tests?