Database indexes are conceptually very simple, but in practice, I’ve found that it’s hard to predict when they’ll get used and what indexes a given table needs. On a project at work I came up with the idea to test-drive my database indexes, just like I test-drive the rest of my code. I’d like to share the approach I came up with.
A very interesting idea at least for MySQL users.
Original title and link: Test Driving Database Indexes ( ©myNoSQL)