Add SQL Wizard: SQL Information Page
View Add SQL Wizard - SQL Information Page
The SQL Information page of the Add SQL wizard is where to enter the SQL text and view various information about the SQL statement, such as the query and abstract plans.
Left pane
Enter the SQL text.
Right Pane
At the top of the right pane are buttons that display the query plan, the abstract plan, Trace On information, the SQL classification and connection information, and the DDL for creating any temporary tables used by the SQL statement.
Check SQL button
Checks the SQL syntax using the current database connection and retrieves the query plan, SQL type classification and other information relating to the SQL statement. To get the query plan most appropriate for your SQL statement, make sure that you have made the corresponding selections from the Settings tab before retrieving the checking the SQL.