Printable View
Hi Friend,
I am using one table which is partitioned by range.
I created seven partition on this table.
I want to create index on six partitions while i dont want to
create index on one partition because in which insertion is going on and if index exist on that partition it slow downs insertion.
Is there any way to create index in such way.
Pl also suggest syntex to crete index in such a manner.
Thanks
Jayesh
You have to create the index for the full table(All the seven partitions).if you are sure that you will not use any dml opertions in the other 6 partitions .You have to redo the design of your application slightly.
1.create a table structure similar to the partition table.
2.do the exchange partition with the newly created table.
3.do all your dml operations on the new table.
Modify your applications for the same.