Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2015
    Posts
    2

    Unanswered: Table reorg after index reorg

    I do table reorg and index reorg for the purpose of oltp maintenance. Is there any benefit of doing index reorg prior to doing table reorg or vice versa? i mean will online index reorg improve the speed of online table reorg? Does the table reorg utlility gains any reorganizing speed with better index cluster ratio?

    Thanks

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    If you you do a classic (offline) reorg of the table, the indexes will be rebuilt in the process, so there is no need to reorg them separately.

    Andy

  3. #3
    Join Date
    Aug 2013
    Posts
    80
    In this case, in what situation we need to reorg index ?

Posting Permissions

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