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

Thread: question about exhcange partitions

  1. #1
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334

    question about exhcange partitions

    version 8.1.7, Sun Solaris.

    We have some code has been provided to us which is a little slow and we need to provide feedback.

    it uses the exchange partition bit of code and what i wanted to know is wat happens to the indexes on these tables, do they become corrupt or unusable?

    If not it is quicker to drop the index and recreate after the exchange has been completed?

    Id test it if I could but at the moment I can't

    Thanks

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    global yes, local no
    Jeff Hunter

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