Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696

    Unanswered: Drop index at partition level

    Is there anyway to drop an index at the partition level in SQL 2005 ?

    There is a way to rebuild at the partition level (assuming this creates)
    i.e.: alter index ALL on dbo.LP_CQ rebuild partition = 229 ;

    I want to:
    1. Drop index(es) at partition level (partitioned by period value (1..400)).
    2. bulk copy data in (can be 1 or more periods per day).
    3. Rebuild at Partition level.

    Thx

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    I haven't tried it, but have you checked DISABLE on a partition level? To re-enable you will have to rebuild, which follows your requirements.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

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