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.
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.
Text to search for filtering SQL statements displayed in the grid.
List of each unique connection for the SQL statements saved in the history list.
List of each unique action type for the SQL statements saved in the history list.
Narrows the SQL statements displayed in the grid according to the selections in the SQL Text, Last Connection, and Last Action drop-down boxes.
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.
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. |
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 |
Enter or select text to filter the SQL statements displayed in the grid. | |
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. | |
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 in the SQL History window.
SQL statements used in several functions are saved so that you can use them again.
To recall a SQL statement
Click .
Select the SQL statement that you want to use.
Click one of the following buttons:
Button | Function |
|
|
|
|
|
|
|
|
|
Copy SQL and Close Window |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Nutzungsbedingungen Datenschutz Cookie Preference Center