Capturing SQL statements from the routine editor

You can capture SQL statements that you are writing or editing in the routine editor.

Before you begin

Procedure

To capture a query from an open routine editor:

Right-click the open routine and select Start Tuning.

Results

If the routine contains more than one SQL statement, the workflow assistant for query tuning opens to the Capture SQL from Routine Editor page of the Capture section.

If the script contains only one SQL statement, the workflow assistant for query tuning opens to the Run Single-Query Advisors and Analysis Tools page of the Invoke section. The statement appears in the Query Text field.

For help with the Capture SQL from SQL Editor page or the Run Single-Query Advisors and Analysis Tools page, click the Help icon (Help), or click in a portion of the page and type F1.


Feedback