reorg rebuild table versus reorg rebuild table index
Reorg rebuild Tablename Indexname allows the table to still be used while the reorg is running.
Reorg rebuild tablename (without the index) causes the table to be blocked.
Reorg Compact is a good way of dealing with forwarded rows while the table is still actively being used.
Reorg Index maintenance and Reorg Compact maintenance are great ways of dealing with huge tables that cannot afford downtime.
I have not used the time options for the reorg command.
I believe it is better to use the “Reorg Compact” followed by “Reorg Rebuild Tablename Indexname”…
because the reverse would disturb cleanly built indexes.
February 20, 2014
If you are really in a hurry to fix slow reads (caused by forwarded rows) then the “forwarded_rows” option of reorg may offer some relieve if there is room on the original page.
Reorg Forwarded_rows Tablename
Keep reading this blog as time goes by to see how I improve my table performance.