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

Move or Copy Jobs to Other Group

SQL Scanner > Move or Copy Jobs to Other Group

To move or copy Jobs in the SQL Scanner to another Group

  1. Mark the Jobs to be moved or copied.

  2. Select Group | Move to Other Group or select Group | Copy to Other Group.

  3. Select Group where the Jobs are being moved or copied from the list.

  4. Click OK.

 

Related Topic

Switch Database and User

SQL Scanner > Switch Database and User

To change the database used to scan a particular Job in the SQL Scanner window

  1. Right-click the job and select Use Database.

  2. Select the database name.

To change the user used to scan a particular Job in the SQL Scanner window

  1. Right-click the job and select Set User.

  2. Select the user name.

 

Related Topic

Modify a Job

SQL Scanner > Modify a Job

To modify a Job in the SQL Scanner window

Right-click and select Modify.

The Modify Job dialog field allows you to do the following:

  • Modify Job description

  • Change the file type

  • Eliminate duplicate SQL while scanning.

When modifications are made to a Job, it must be rescanned.

 

Related Topic

Placing Bookmarks in SQL Scanner

SQL Scanner > Placing Bookmarks in SQL Scanner

Place 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

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating