Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.8 - 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

Open SQL from SQL Repository

SQL Information and Functions > Open SQL from SQL Repository

SQL statements saved in the SQL Repository can be copied into the SQL Optimizer, SQL Formatter, or SQL Worksheet.

To open a SQL statement from the SQL Repository

  1. In the SQL Optimizer, SQL Formatter, or SQL Worksheet., select Edit | Open SQL from SQL Repository.

  2. Navigate through the tree structure and select the SQL statement.

  3. Either double-click the SQL statement, or click Open.

 

Related Topic

SQL Repository Overview

Save SQL to SQL Repository

SQL Information and Functions > Save SQL to SQL Repository

If you are using this function from the SQL Scanner, you can send multiple SQL statements to the SQL Repository. If you are using this function from the other modules, you can send one SQL statement to the SQL Repository.

To save multiple SQL statements to the SQL Repository module

  1. In the SQL Scanner, select the Job which contains the SQL statements. In the SQL Inspector, click in the SQL Text pane.

  2. Click Save SQL to SQL Repository image\B_SaveSQLtoSQLRepository.gif.

  3. Select the location in which to save the SQL statements and click OK.

To save a SQL statement to the SQL Repository module

  1. In the modules with a SQL Text window, select a SQL statement.

  2. Click Save SQL to SQL Repository image\B_SaveSQLtoSQLRepository.gif.

  3. Select the location in which to save the SQL statements and click OK.

Only valid SQL statements are added to the SQL Repository.

Note: The SQL Repository only supports a single SELECT, INSERT, UPDATE or DELETE SQL statement.

 

Related Topic

SQL Repository Overview

Create Benchmark Factory Import File

SQL Repository > Create Benchmark Factory Import File

All the SQL statements can be saved in a text file from the SQL Scanner, the SQL Repository, the SQL Inspector, and the SQL Optimizer windows. These SQL statements can then be imported into Benchmark Factory 4.6 or later.

To create a file to import into Benchmark Factory

  1. Right-click and select Create Benchmark Factory Import File.

  2. Select the specific SQL statements that you want to save.

  3. Enter the filename and select the file location.

 

SQL Navigation

SQL Information and Functions > SQL Navigation

You can navigate through multiple SQL statements tabs using the following methods.

  • Click the tab set located at the bottom of the window.

  • Use the SQL | Go to SQL function which navigates to a specify SQL number.

  • Use the navigation buttons on the toolbar or select the corresponding menu item.

Menu Button

Navigate | First SQL

image\B_FirstSQL.gif

Navigate | Previous SQL

image\B_PreviousSQL.gif

Navigate | Next SQL

image\B_NextSQL.gif

Navigate | Last SQL

image\B_LastSQL.gif

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating