Use DB2 optimization techniques to get and maintain a good query execution plan
Angela Yang · 2010
The DB2 optimization profile is often used as a work around to get a required query execution plan when the DB2 optimizer failed to produce a good plan. However users often find it challenging to use. Part of the reason is documentation has been focused on the command line processor (CLP). It lacks coverage with concrete examples on profile usage in applications, like Java and SQL procedure, which are more widely used.