Unanswered: Index Cluster Ratio doens't improve after ReOrg Table/Index
The db2 mornitoring tools indicates there are several tables and indexs need to be reorg, especially indexes. I ran reorg on the tables and indexes and runstat after that. However the cluster ratio is't changed from Indexes. Any advise would be appreciated!!
Thank you for your post. Understood! Just wondering I was referrring table(s) where only one index is defined. I was reorg the table with the index then update statistics...but it does change nothing..
Thank you for all. I will check the option if I can reorg tables clustering using index then see if it makes any change of ratio.
Just one follow up questions.....any different result if I reorg online vs. offline?