Tip #2
1/7/2019

  • Tip

    After reorging a table, do you need to reorg its indexes?

  • That depends on whether your REORG TABLE is offline reorg or online(aka. INPLACE) reorg.

    Following offline table reorg, no need to reorg its indexes, because the last phase of offline
    table reorg will rebuild its indexes anyway.

    However, online table reorg does not rebuild the indexes. Therefore after the completion of
    online table reorg, REORG INDEXES is recommended.