What is Composite index?

An index on several columns in a set order. It helps queries that filter on those columns starting from the left.