Creating a Local Index Across Multiple Tablespaces

The following statement is an example of creating a local index on a table where the index segments are spread across tablespaces ts7, ts8, and ts9.

CREATE INDEX employee_ix ON employees_range_hash(department_id)
     LOCAL STORE IN (ts7, ts8, ts9);

This local index is equipartitioned with the base table so that it consists of as many partitions as the base table. Each index partition consists of as many subpartitions as the corresponding base table partition. Index entries for rows in a given subpartition of the base table are stored in the corresponding subpartition of the index.