Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002

    Unanswered: Type 2 indexes, do they drop when reorged

    With the new type 2 indexes, you need to reorg the indexes from time to time to clean them up. When you run it does it just drop the index or does it actually try to re-organize it? If you select the allow write access does it drop the index, and does it allow the user to still use the index?
    David Quigley

  2. #2
    Join Date
    Aug 2001
    My assumption is that the index will not be dropped .. You should be able to continue using the table and index when the reorg is happening if you specify ALLOW WRITE ACCESS ..

    The reorg is generally done in the tempspace or another tablespace you specify and then the original index is 'swapped' for the new one ... Even if you specify ALLOW WRITE ACCESS there will be a short period of time when the index will not be available .. By default, The INPLACE reorg is different and happens asynchronousely ..

    But, the bottomline, to my understanding is, the index is not dropped

    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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