380 HA Architectures & Capacity Planning with WebSphere Remote Server V6
the pages of the table become full, records are appended to the end of the table
so that the table gradually becomes unclustered.
11.6.3 Index management
The most important thing for performance in the database design is the index.
When designing the index on tables, you need to understand how the tables will
be accessed by the application. First, determine which queries will be used on
the database. Then analyze the statements by yourself or use the
Design
Advisor
provided by DB2 UDB.
After the data are loaded into the tables, run the runstats utility to update the
statistics on the tables so the optimizer can use the indexes. For frequently
updated tables, run the
runstats ...