Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.9.1 - User Guide

Introduction Tutorials Preferences Editor Functions SQL Information and Functions Performance Monitor SQL Inspector SQL Collector for Monitor Server SQL Scanner Index Advisor SQL Optimizer
SQL Optimizer Overview Optimization Engine Common Coding Errors in SQL Statements What Function Should l Use to Retrieve the Run Time? Unsatisfactory Performance Results SQL Optimizer Functions SQL Editor Optimized SQL Activity Log
SQL Worksheet SQL Formatter Database Explorer Code Finder Object Extractor SQL Repository Index Impact Analyzer Index Usage Analyzer Configuration Analyzer Migration Analyzer Abstract Plan Manager User-Defined Temp Tables SQL History Legal Information

SQL History Overview

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

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

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

  1. 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.

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

 

Related Topics

Recall SQL Statements

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

To recall a SQL statement

  1. Click image\B_SQLHistory.gif.

  2. Select the SQL statement that you want to use.

  3. 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

 

Related Topics

Related Documents