multicolumn index

Also written: composite index

An index on several columns, sorted by the first and then the next. It serves queries on the leading columns, so order matters.