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.