REORG TABLESPACE - Reorganizes |all data and all indexes.
REORG TABLESPACE PART n - Reorganizes data for PART n of the table space and PART n of all partitioned indexes.
REORG TABLESPACE |PART n:m - Reorganizes data for PART n through PART m of the table space and PART n through PART m of all partitioned indexes.
sometimes reorg index is all you need, and then there is no point in wasting time and cpu to reorg everything.
I like that type of thinking. All too often, people are just too lazy to make a little change to just do what is needed, and not all the stuff which "doesn't matter if it is done anyway" but which takes time. Then they sit there pressing enter every 20 seconds, hoping for a NOTIFY.
GuyC is off out the door with work done, whilst the "lazy" is still hard-at-it pressing enter :-)