Partition Elimination
Hi All,
Could you please clarify my doubt in partition elimination.? I have two tables TRA and TRA_DATE. TRA is partiotion by date column and further sub partitioned by string column. TRA_DATE has date column as well as the string cloumn.
ALTER SYSTEM FLUSH SHARED_POOL;
DROP TABLE TRA;
DROP TABLE TRA_DATE;
CREATE TABLE TRA(VDATE DATE, SIT VARCHAR2(10),DATA VARCHAR2(100))
PARTITION BY RANGE (VDATE)
SUBPARTITION BY HASH(SIT)
(
PARTITION TRA2007 VALUES LESS THAN( TO_DATE('01-JAN-2008 00:00:00','dd-MON-YYYY HH24:MI:SS') )
SUBPARTITIONS 1,
PARTITION TRA2008 VALUES LESS THAN( TO_DATE('01-JAN-2009 00:00:00','dd-MON-YYYY HH24:MI:SS') )
ALTER SYSTEM FLUSH SHARED_POOL;
DROP TABLE TRA;
DROP TABLE TRA_DATE;
CREATE TABLE TRA(VDATE DATE, SIT VARCHAR2(10),DATA VARCHAR2(100))
PARTITION BY RANGE (VDATE)
SUBPARTITION BY HASH(SIT)
(
PARTITION TRA2007 VALUES LESS THAN( TO_DATE('01-JAN-2008 00:00:00','dd-MON-YYYY HH24:MI:SS') )
SUBPARTITIONS 1,
PARTITION TRA2008 VALUES LESS THAN( TO_DATE('01-JAN-2009 00:00:00','dd-MON-YYYY HH24:MI:SS') )
0