Mark A wrote:
"Bob [IBM]" <Bo********@gmail.com> wrote in message
news:45************@individual.net... Unless you are doing an inplace reorganization, you do not need to
reorganize the indexes as they will be rebuilt with the standard (classic)
offline reorg. If you do an inplace reorg then only the data is
reorganized and then you can consider an index reorganization.
Bob
Any chance of getting a doc change? There is no mention of this that I can
see in the Command Reference.
The following is from the local Information Centre (installed on my
laptop) and on the web version of the Information Centre. Note the last
sentence:
REORG INDEXES/TABLE Command
....
Indexes might not be optimal following an in-place REORG TABLE
operation, since only the data object and not the indexes are
reorganized. It is recommended that you perform a REORG INDEXES after an
in place REORG TABLE operation. Indexes are completely rebuilt during
the last phase of a classic REORG TABLE, however, so reorganizing
indexes is not necessary.
Here is the link for reference:
http://tinyurl.com/pycn3
I also had a look at the V8.2 Command Reference (downloaded from the
web) and the same statement is found in the REORG TABLE section towards
the end.
Bob