When will REORG work efficiently even if I have not designated a clustering index?


  Solution
In Version 8, REORG recognizes the same implicit clustering index that the data manager uses for INSERT. If you have never explicitly specified CLUSTER YES on one of your indexes, DB2 INSERTs use the first index that was created to order the data. Beginning with Version 8, REORG will follow that same clustering. Also, as part of online schema, you will have the ability to change that CLUSTER YES attribute of an index with an ALTER rather than having to drop the index and recreate it. So if you decide to change that CLUSTER YES attribute, the quick change becomes effective at the next REORG.


P.S. Please pass my address to anyone interested in DB2 HOTLINE - thank you.

With kind regards
Michael Dewert, Software GroupTechnical Sales DB2