In addition to the factors you should consider when you are designing and coding your application (described in Chapter 10. "Application Considerations"), there are environmental factors that can influence the access plan chosen for your application:
Also refer to Chapter 12. "System Catalog Statistics" for more information about factors that affect the SQL optimizer.
When tuning your applications and environment, you should rebind your applications after you make changes in any of the above areas. This ensures that the best access plan is being used.
[ DB2 List of Books | Search the DB2 Books ]