Description of the illustration cncpt297.eps
This graphic shows the following partitions:
Table Partition PARTITION_SALES_1998
PROD_ID CUST_ID TIME_ID CHANNEL_ID PROMO_ID QUANTITY_SOLD AMOUNT_SOLD
---------- ---------- --------- ---------- ---------- ------------- -----------
40 100530 30-NOV-98 9 33 1 44.99
125 9417 04-FEB-98 3 999 1 16.86
45 9491 28-AUG-98 4 350 1 47.45
Table Partition PARTITION_SALES_1999
PROD_ID CUST_ID TIME_ID CHANNEL_ID PROMO_ID QUANTITY_SOLD AMOUNT_SOLD
---------- ---------- --------- ---------- ---------- ------------- -----------
116 11393 05-JUN-99 2 999 1 12.18
36 4523 27-JAN-99 3 999 1 53.89
24 11899 26-JUN-99 4 999 1 43.04
Table Partition PARTITION_SALES_2000
PROD_ID CUST_ID TIME_ID CHANNEL_ID PROMO_ID QUANTITY_SOLD AMOUNT_SOLD
---------- ---------- --------- ---------- ---------- ------------- -----------
133 9450 01-DEC-00 2 999 1 31.28
35 2606 17-FEB-00 3 999 1 54.94
Table Partition PARTITION_SALES_2001
PROD_ID CUST_ID TIME_ID CHANNEL_ID PROMO_ID QUANTITY_SOLD AMOUNT_SOLD
---------- ---------- --------- ---------- ---------- ------------- -----------
118 133 06-JUN-01 2 999 1 17.12
30 170 23-FEB-01 2 999 1 8.8