Optimizing database query performance

The RUNSTATS command updates the database query access plan for each table and index. To optimize database query performance, run RUNSTATS at least once a week when IBM WebSphere Business Integration Connect application and database activity is at a minimum. As database traffic increases, run RUNSTATS more frequently - up to once a day.

Note:

Copyright IBM Corp. 2003, 2004