Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005
    Posts
    3

    Unanswered: Alter / Drop index that are using Daily partitions

    Another wonderful question for the board.

    I have some indexes I am trying to rebuild that are using daily partitions. Is there a way to drop specific partitions from the index I need to rebuild and then only rebuild the index for the partitions that were dropped?

    Or do I need to drop the entire Index and rebuild the entire thing?

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    Why do you need to drop the index partition? just do 'alter index <> rebuild partition<> online' for those partition which need it.

    Alan

Posting Permissions

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