Results 1 to 3 of 3

Thread: Rebuild indexes

  1. #1
    Join Date
    Oct 2009
    Posts
    14

    Unanswered: Rebuild indexes

    Hi,

    Is there any concept of Rebuilding Indexes in db2 UDB LUW just like in Oracle?

    Please correct me if i am wrong. I think "Reorg" utility will not only defragment the indexes but also rebuild the indexes? Infact it is only the way to rebuild manually?


    Thanks!

  2. #2
    Join Date
    Jan 2010
    Posts
    335
    That is correct. The normal reorg is rebuilding the indexes. The reorg comand has an option 'clean up' which frees used pages.

    REORG INDEXES/TABLE

  3. #3
    Join Date
    Oct 2009
    Posts
    14
    Thanks for clearing the doubt!

Posting Permissions

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