Reorg

[Asphalt Blazer]

Whenever I do an offline reorg I see that indexes for the table are
being rebuilt(on the db2diag.log). Does that mean I do not need to
reorg the indexes for these tables separately? This is the command I
use - reorg table <table nameallow no access

Thanks

[krx]

On Mar 7, 11:03 am, "Asphalt Blazer" <[e-mail]:

Whenever I do an offline reorg I see that indexes for the table are
being rebuilt(on the db2diag.log). Does that mean I do not need to
reorg the indexes for these tables separately? This is the command I
use - reorg table <table nameallow no access

Thanks

>From documentation,

Indexes are completely rebuilt during the last phase of a classic
REORG TABLE, however, so reorganizing indexes is not necessary.