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