Databases Reference
In-Depth Information
Figure 6-1. Locally partitioned index architecture
The Simplest Form
Creating a locally partitioned index is, at its most basic form, identical to creating a non-partitioned
index—except for the
LOCAL
keyword.
SQL> CREATE INDEX employees_part_1i
2 ON employees_part (hire_date)
3 TABLESPACE empindex_s
4 LOCAL;
Index created.
For this example, the partition names Oracle will create will have the same names as the data partitions.
Furthermore, all partitions will be created in the
EMPINDEX_S
tablespace.
Based on the requirements of your application you may need to specify partition-specific
information, such as the following:
•
Partition name
Tablespace name
•
Storage parameters
•
