The profiling feature lets you submit one or more SQL tab statements for tuning by the tuning feature. This lets you take advantage of tuning's hint-based and transformation-based suggestions, detailed execution statistics, and explain plan costing, in tuning a statement.
To open a tuning job on a statement appearing on the SQL tab of the profiling editor
- Select one or more statements, right-click and select Tune from the context menu. Tuning opens on the selected statement.
For more information, see Tuning SQL Statements in the Using Tuning section of this guide.