SQL tab

The SQL tab opens when you select a statement in the Performance perspective, or when you create a tuning session for an ad hoc SQL statement.

If you select a statement from a package or from the statement cache, the statement is displayed in the SQL tab.

Tip

If you want to edit a statement selected from the statement cache or from a package, you must create a What-If scenario.

If you are creating an ad hoc tuning session, you must enter the statement into this pane. You must also populate the other fields. For more information, see Analyzing-an-ad-hoc-statement.

Important

After the statement has been explained, click What-If NW_create_what_if.png to modify the statement, or enter new parameters to run a subsequent Explain.


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*