In this article, we will analyze how composite index can help us with better query response time from DB. In SQL, a composite index is an index built on multiple columns within a table, instead of just one. 

If you go through the first part of this article SQL Query Performance Tuning in MySQL – Part 1, you would have a better understanding of setup.

Leave a Reply

Your email address will not be published. Required fields are marked *