-
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.
Radhakrishnan.M
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|