This example defines an index for the EMPLOYEE_NUMBER column. Note that you cannot define an index for an abstract data type column.

Example

CREATE INDEX INDX1 ON STAFF_TABLE (EMPLOYEE_NUMBER)
 IN ((RDAREA03),(RDAREA04));

Explanation:

For the row-partitioned STAFF_TABLE, partitioning key index INDX1 is divided and stored in user RDAREAs RDAREA03 and RDAREA04. EMPLOYEE_NUMBER is specified for the columns that constitute the INDX1 index.