First page Back Continue Last page Graphics

Indexes Part 3 Workshop: Function-based Indexes


Notes:

Function Based Indexes Workshop
Create a bitmap index on the TITLE column of the EMPLOYEE table. Try to get the optimizer to use.
Create a function-based BITMAP index on the TITLE column of the EMPLOYEE table. Try to get the optimizer to use.
Query the USER_INDEXES table to show the index_name and index_type for all indexes on the EMPLOYEE table.