Can you explain the concept of a composite index?

A composite index is an index that involves more than one column in a table. It's used

when queries often filter or sort by multiple columns, optimizing performance for those

specific queries.