DB2 UDB Reorganizationgreenspun.com : LUSENET : DBAzine : One Thread
I have a table of 12 GB, whose Primary Index's cluster ratio is below 50% . The reorgchk utility suggest me to reorganize the Index.
We have Db2 V7.2 fixpak 6 on AIX 4.3.3 with SAP 4.6D. My Query is : 1. What is the idifference between Table reorganization and indexreorganization ? 2. How will I do Index Reorganization ? 3. If I reorg the table using the primary key, what about the other non-unique indexes. How do I reflect the changes on other indexes ? How will my query performance be enhanced if it is using other indexes ? 4. What exactly is the difference between Random Read and sequential read ? Please clerify ? Thanks & Regards, Jayesh
-- Jayesh Dhanani (email@example.com), July 10, 2003