Well, I have a table with the following structure and I need to add a new RANGE by adding the field People_Subscription_Start_DT:
PARTITION BY RANGE_N (People_Subscription_Start_DT DATE '2008-09-01' AND DATE '2013-12-31' EACH INTERVAL '1' DAY, NO RANGE);
My question to all of you is: Do I need to add the field People_Subscription_Start_DT as part of the PPI? Is it a MUST when adding a RANGE to put the field as the PPI?
Thanks in advance
CREATE MULTISET TABLE TR_PEOPLE_ACT ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
People_Subscription_Start_DT DATE FORMAT 'YYYY-MM-DD',
People_Subscription_End_DT DATE FORMAT 'YYYY-MM-DD',
PRIMARY INDEX PI_TR_PPL_ACT ( People_ID)
you do not need to add the field People_Subscription_Start_DT in PPI.
yes you need PPI if you want to add range.