Properly creating indexes on database tables is a key ability and one that many developers have little confidence in (i.e., it’s a common question I see). I’ve written about the subject in my books, on my blog, and in my newsletter, but I recently StumbledUpon a good, quick article on the subject over at Kyle’s Cousin that I thought I’d share. The article only dips its toe into the subject, but what it does well is two things. First, it demonstrates how you can confirm the effectiveness of indexes. And second, it explains what’s going on behind-the-scenes to better understand when and why indexes will be effective.
An Absolute Beginner’s Introduction to Database Indexes
