Answer:
A concatenated index, also known as multi-column, composite, or combined index, is one index across multiple columns. In the case of queries with multiple equality conditions, even though multiple single-column indexes can result in a very good performance, a single concatenated index solution is preferable.
