Creating and deploying plan hints

You can create, validate, and deploy a plan hint for an SQL statement that runs on a DB2® for z/OS® subsystem. With a plan hint, you can set criteria to assist the DB2 optimizer to select the optimal execution plan for the SQL statement.

Before you begin

About this task

Procedure

To open the Customize Access Plan with Plan Hint page, so that you can create or edit a plan hint:

What to do next

For help with creating, validating, and deploying plan hints, click the Help button at the top of the page and in the windows that you open. You can also type F1 for help.

Feedback