Function-Based Indexing on LOBs

A function-based index is an index built on an expression. It extends your indexing capabilities beyond indexing on a column. A function-based index increases the variety of ways in which you can access data.

Function-based indexes cannot currently be built on nested tables. However, you can now build function-based indexes on LOB columns and varrays.

See Also: Oracle9i Application Developer's Guide - Fundamentals, for more information about using function-based indexing.