Database Indexes Explained Like You're 5

If your queries are slow and you're not sure why, this is probably the article you need. No jargon, just analogies and SQL.