Page History
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.
| Info |
|---|
Setting the bind variables in a parent statement sets the bind variables in all generated cases for that statement. |