Hello,

When DB2 tables have fragmentation you issue a reorganize table command
as follows.

db2 reorg table myschema.my_table use temp_4k

Does the following statement reorganize a fragmented index or reorganize
the table sorting the data by my_index1?

db2 reorg table myschema.my_table index myschema.my_index1 use temp_4k


Shannon Wood

specified. If a clustering index is defined, no index need be specified (and
if specified it must be the same as the clustering index). All indexes will
be rebuilt as part of the reorg, so long as an "inplace" reorg is not
specified.