•Try
using the OPTIMIZE for N rows
•Investigate
using QAQQINI to set options for how queries are
optimized
–Turn
OFF treat constants as parameters
–Use
OPTIMIZE_STATISTIC_LIMITATION to allow optimizer to
"see" more values in the logical files
–Use
FORCE_JOIN_ORDER to force optimizer to link files in order named
in query