Range Partition Performance! [message #170657] |
Thu, 04 May 2006 12:24 |
rkulasek
Messages: 15 Registered: April 2006
|
Junior Member |
|
|
Hi -
I created Range partition for a table using following code --- but when I compare queries on the non-partitioned table and this range-partitioned table, I find that the non-partitioned table is still faster all the time !
We are using Oracle 10g. Do I need to set any Oracle parameters for range partitioning to work?
Any ideas please?
Thanks
Raja
=========
create table mytable partition by range(my_time) (partition part1 values less than (to_date('01-MAR-2006','DD-MON-YYYY')),partition part2 values less than (to_date('01-APR-2006','DD-MON-YYYY')),partition part3 values less than (to_date('01-MAY-2006','DD-MON-YYYY')) ,partition PARTMAX values less than (MAXVALUE) ) as (select * from base_table);
create unique index pk_myindex on mytable(my_time,mykey,myid) local (partition part1 ,partition part2 ,partition part3 ,partition part4);
alter table mytable add constraint myconstraint primary key(my_time,mykey,myid);
=========
|
|
|
|
|
|