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.