DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to create index in particular table partition

  1. #1
    Join Date
    Nov 2000
    Posts
    34

    Question

    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

  2. #2
    Join Date
    Sep 2000
    Posts
    384
    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
  •  


Click Here to Expand Forum to Full Width