Using Optimization Hints

Srini S Rajan

Using Optimization Hints

To avoid performance mismatches in some queires between test and
production environments, I am planning to recommend optimization
hints using OPTHINT for my development team.

Can you let me know from your experience, what could be possible
bottlenecks with this approach and other suggestions.


Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at