All Forums Database
Rob Katofiasc 2 posts Joined 11/11
20 Dec 2012
Add partitions to multi-level ppi

We have a table defined as follows:
 
 
CREATE MULTISET TABLE dw_dev.rfk_IMP
……..
PRIMARY INDEX ( v_ID )
PARTITION BY ( RANGE_N(YEAR_MONTH  BETWEEN 201205  AND 201212  EACH 1 , NO RANGE, UNKNOWN),
                        RANGE_N(DATE_ID  BETWEEN DATE '2012-05-01' AND DATE '2012-12-31' EACH INTERVAL '1' DAY , NO RANGE, UNKNOWN),
                        RANGE_N(WEB_PAGE_TYPE_ID  BETWEEN 2000  AND 2300  EACH 1 , NO RANGE, UNKNOWN)
                      )
INDEX SI_CUSTID ( CUSTOMER_ID );
 
 
How do we extend the partitions for level 1 and level 2?

KS42982 137 posts Joined 12/12
27 Dec 2012

Can you be more specific ? What exactly you want to extend ? The interval of the partition ?

You must sign in to leave a comment.