Test Driving Database Indexes
Myron Marston:
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)
via: http://myronmars.to/n/dev-blog/2012/09/test-driving-database-indexes
