Databases Reference
In-Depth Information
Figure 6-2. Globally partitioned index architecture
You can create the following types of globally partitioned indexes:
•
Range
Hash
To show an example for a range-based globally partitioned index, for your
EMPLOYEES
table, you find
out there are many requirements to query by
MANAGER_ID
, so you can therefore create a partitioned index
on the
MANAGER_ID
column, with the partitioning being completely independent of the table. See the
following example of a range partitioned index:
SQL> CREATE INDEX employees_gi2
2 ON employees (manager_id)
3 GLOBAL
4 partition by range(manager_id)
5 (partition manager_100 values less than (100),
6 partition manager_200 values less than (200),
7 partition manager_300 values less than (300),
•