Oracle9i™ Development by Example

Composite Partitioning

Composite partitioning is a combination of range and hash partitioning. Notice in Figure 15.3 that each partition is now subdivided into four additional subpartitions. Listing 15.4 is the syntax used to support Figure 15.3. Each partition named P1, P2, P3, and P4 would contain the range of dates as defined by the STORE IN clause. The SUB PARTITIONS 4 clause subdivides each of these partitions into four logical units. The SUBPARTITION BY HASH clause, on the other hand, equally divides the rows that meet the range criteria, using the ST_CUSTOMER_ID as the hash key to evenly distribute the rows throughout these four subpartitions.

Figure 15.3. ST_SALES composite partitioned table.

This example gives the ST_SALES object a total ...