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.

Related topics

Performance perspective

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*