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.