Hi all ,
I have a requirement that i have crores of datas to be processed in a year,
For performance sake,
I have created range partition on a table depending on dates,
like
PARTITION BY RANGE (sys_dt)
(PARTITION part1 VALUES LESS THAN (TO_DATE('01/03/2003', 'DD/MM/YYYY')),
PARTITION part2 VALUES LESS THAN (TO_DATE('01/03/2004', 'DD/MM/YYYY')),
PARTITION part3 VALUES LESS THAN (TO_DATE('01/03/2005', 'DD/MM/YYYY')),
PARTITION part4 VALUES LESS THAN (TO_DATE('01/03/2006', 'DD/MM/YYYY')),......
PARTITION part5 VALUES LESS THAN (MAXVALUE)
)
suppose i want 1 year of data like from this july , then according to the partition i created , its going to access part2 and part3 , again its going to be performance issue , is there any other method where i can avoid it or is this the only solution .


thanks in advance