View Source

The Tuning job's Overview tab let you open a statement in an SQL Viewer if you want to perform either of the following tasks:

View the entire SQL statement.
Set bind variables. If the Tuning Status Indicator indicates a statement or case has invalid bind variables, you must set those variables before executing the statement or case.

To view or set bind variables in a statement or case

Right-click a statement or case and select Edit.
Use the Data Type and Value (or NULL) controls to specify the type and value for each bind variable.
After setting bind variables, you can execute a case.

Setting the bind variables in a parent statement sets the bind variables in all generated cases for that statement.