Compound index

Also written: compound indexes

An index on several fields, sorted by the first and then by the second within each first value. Order the fields equality, then sort, then range.