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

Placing Bookmarks in SQL Scanner

Bookmarks are used to mark a Job in the SQL Scanner window to indicate such things as:

  • You are currently working on a Job.

  • You have finished reviewing a Job.

  • You have determined the critical Jobs to be reviewed first.

If the row contains a bookmark, the complete row text is displayed in fuchsia color. You can have multiple bookmarks.

To place or remove a bookmark in the SQL Scanner window

Right-click on a job and select Add/Remove Bookmark.

 

Related Topic

Open in SQL Collector

In the SQL Scanner if the Job is a Collector file, you can open the Collector file in the SQL Collector window to view the SQL statements.

To open the SQL Collector window

Right-click the job that want to open in the Job List pane and select Open in SQL Collector.

 

Related Topics

Open in SQL Inspector

In the SQL Scanner if the selected Job is an Inspector file or the selected SQL statement, you can open the Inspector file in the SQL Inspector window to view the statistics and charts.

To open the SQL Inspector and display the statistics

Right-click the job that want to open in the Job List pane and select Open in SQL Inspector.

 

Related Topics

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.

 

Related Documents