Описание тега composite-index
Composite index: An index that contains more than one column.
A composite index is useful when there are multiple fields in the WHERE clause of an SQL statement and all fields combined will give significantly less rows than the first WHERE clause field.