Page History

Once you have created a tuning job and named it, using File > Save As, you need to add SQL statements to the job that are to be tuned. All standard DML statements can be tuned (SELECT, INSERT, DELETE, and UPDATE as well as MERGE on SQL Server 2008 and higher).

Statements are added to tuning via the Overview pane. 

...

• New SQL Text enables tuning via manual entry, or cutting and pasting into the tuning window.
• Extract from Database Objects enables you to select stored SQL from the data source to which you are connected. You can either drag and drop objects from the Data Source Explorer or you can add database objects matching specified filers. For example, entering t in the filter area of the Data Source Objects Selection dialog, can match functions, materialized views, procedures, and views, whose name begins with t. You can then drag and drop the matches from the Data Source Explorer to the Tuning Statements grid.
• The Import from File (Workspace) and Import from File (System) options enables you to choose an SQL file saved in your workspace or elsewhere on your computer or network.
• The Scan Oracle SGA option is available for the Oracle platform only. It enables you to scan for and select active SQL in the System Global Area (SGA). For more information, see Tuning SQL Statements statements in the System Global Area (Oracle).

To add an ad hoc SQL statement:

...