SQL Optimizer for SAP ASE 3.9

Throughout the program, SQL statements are saved in the SQL History so that you can use them again. They are stored in a file so that they are always available to work with again.

Related Topics

SQL History Window

SQL History Functions

SQL History Window

SQL History > SQL History Window

View SQL History Window

The SQL History window displays the SQL statements that were used in several modules. The functions that can save SQL are Optimize, Advise Indexes, Run Time, Run Result, Show Plan and Execute. The Preferences settings determine in which functions the SQL statements are saved.

SQL Text drop-down field

Text to search for filtering SQL statements displayed in the grid.

Last Connection drop-down field

List of each unique connection for the SQL statements saved in the history list.

Last Action drop-down field

List of each unique action type for the SQL statements saved in the history list.

Apply Filter Button

Narrows the SQL statements displayed in the grid according to the selections in the SQL Text, Last Connection, and Last Action drop-down boxes.

Button Bar

Buttons for copying the selected SQL statement to other modules: Send to SQL Optimizer, Send to Index Advisor, Save SQL to SQL Repository, Copy to SQL Worksheet, and Copy SQL and Close Window.

Grid

Item	Description
No	The SQL statements are numbered as they are saved in sequential order.
SQL Text	The text of the SQL statement. When you click a line, the full text of the SQL statement displays in the bottom pane of the window.
Last Used Datetime	The date and time the SQL was last used in one of the modules.
Last Connection	The connection information for the last time the SQL statement was used.
Last Action	The action that was used which caused the SQL statement to be saved.
Times Used	The number of times the SQL statement has been saved in the SQL History.

Related Topics

SQL History Overview

Filter SQL Statements

Recall a SQL Statement

SQL History Functions

Filter SQL Statements

SQL History > Filter SQL Statements

The SQL statements can be filtered to help you locate the specific SQL statement that you are looking for. Three drop-down boxes provide you with the filtering options.

To filter the display of the SQL statements

Select the filtering criteria from one or more of the list:

List	Description
SQL Text	Enter or select text to filter the SQL statements displayed in the grid.
Last Connection	Select the connection that you want used to filter the SQL statements displayed in the grid. This drop-down list contains a list of the unique connections in the SQL History list.
Last Action	Select the action that you want used to filter the SQL statements displayed in the grid. This drop-down list contains a list of the actions for the SQL statements in the SQL History list.

Click $image\B_ApplyFilter.gif$ in the SQL History window.

Related Topics

SQL History Overview

SQL History Window

Recall SQL Statements

SQL History > Recall SQL Statements

SQL statements used in several functions are saved so that you can use them again.

To recall a SQL statement

Click $image\B_SQLHistory.gif$ .
Select the SQL statement that you want to use.
Click one of the following buttons:

Button	Function
$image\B_SendToSQLOptimizer.gif$	Send to SQL Optimizer
$image\B_CopytoIndexAdvisor.gif$	Send to Index Advisor
$image\B_CopyToSQLWorksheet.gif$	Copy to SQL Worksheet
$image\B_SaveSQLtoSQLRepository.gif$	Save SQL to SQL Repository
$image\B_Copy.gif$	Copy SQL and Close Window