O'Reilly logo
  • Lucas Reis thinks this is interesting:

Multicolumn indexes are known as concatenated indexes. These indexes are especially effective when you often use multiple columns in the WHERE clause when accessing a table.

From

Cover of Pro Oracle Database 11g Administration

Note

Multicolumn index