19 Jan 08
AssertEfficientSql →
The assertion intercepts and copies out your MySQL SELECT statements, then calls EXPLAIN on each one, and inspects the results for common problems. The goal is test cases that resist database pessimization, even as you change your data relations, to add new features. If you run your tests after every few changes, you can easily detect which change broke your database‘s indices and relations. Credits to Jay Pipe for his excellent little survey of ways to detect pessimizations!