There is a time in the project lifecycle when everything is working fine, but the stress test gives really bad results, especially on the web pages where a query traverses through a jungle of rows in the database. What should you do then? The majority of blog posts, articles and forums suggest to add an index on a column in the table, but the theory behind adding indexes goes much deeper. Through this blog post, I'll explain what to do and what not to do in different scenarios. Have you ever wondered how much a well-placed index speeds up your queries?