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

Function-based indexes are created with functions or expressions in their definitions. Sometimes, function-based indexes are required when queries use SQL functions.

From

Cover of Pro Oracle Database 11g Administration

Note

Function index