Reorganizing the WebSphere Commerce Analyzer tables
Over time, when many updates are made to the tables in the WebSphere Commerce Analyzer data mart, the tables can become fragmented. As a result, subsequent operations on the tables, such as insertions, deletions, updates, and queries take longer to perform. If you notice a degradation in query response times, consider reorganizing the tables, especially if the statistics generated by the RUNSTATS command are up-to-date.
To determine if reorganize a specific table, use the REORGCHK command. If the output from this command indicates that reorganize a table to improve performance, use the REORG command to reorganize the tables.
For detailed information about these commands, see the IBM DB2 Command Reference at the following URL:
publib.boulder.ibm.com/infocenter/db2help/index.jsp
(C) Copyright IBM Corporation 1996, 2006. All Rights Reserved.