Results 1 to 2 of 2

Thread: Partitioning

  1. #1
    Join Date
    Sep 2002
    Posts
    4

    Unanswered: Partitioning

    Is there any sense in partitioning only the data and leaving the indexes
    global ?? What will i gain ??

    Thanks
    Raghu

  2. #2
    Join Date
    Oct 2002
    Location
    greenwich.ct.us
    Posts
    279
    Is there any sense in it? Sure. When you have a PK that is not your partition key, that's the only way to go.

    You must be careful when you add/drop/modify/split a partition that has a global or regular index on it. Most often, you will need to rebuild the global/regular index because your partitioning operation has rendered the index unusable.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •