Oracle
Function-Based Indexes
Figo Kim
2007. 1. 10. 22:53
- The Oracle server uses the index only when that particular function is used in a query.
- If the function is not used in a query and there is no specific index, the Oracle server will full scan.
- QUERY_REWRITE_ENABLE initialization parameter must be set to TRUE for a function-based index to be used.
CREATE INDEX upper_dept_name_idx ON dept2(UPPER(department_name)); |