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

Extraction Criteria

Object Extractor > Extraction Criteria

The Extraction Criteria window provides options on how the object DDL displays. These options include:

Place a DROP command before the object

Specify whether to include the DROP command before the CREATE object command.

Qualify object with database and user name

Specify whether to place the database and user name in front of every object in the DDL.

Include indexes for table

Specify whether to include the CREATE INDEX command when the DDL for a table is extracted.

Place comments in script

Specify whether to place a comment before and after the DDL script for each object. The comment includes information on the database, user, object name and date and time of generation.

Show on next extraction

Specify whether to show the Extraction Criteria window next time DDL is extracted. If this window is not shown then the extraction option will be according to last selection.


Related Topics

Object Extractor Functions

Object Extractor > Object Extractor Functions

Below is a list of available functions within the Object Extractor window.

Button or Menu



Extract DDL


Extract to File



Edit Menu


Send to SQL Optimizer

Edit Menu


Send to Index Advisor

Edit Menu


Copy to SQL Worksheet


Related Topics

SQL Repository

SQL Repository Overview

SQL Repository > SQL Repository Overview

The SQL Repository stores the SQL statements that are used in the analysis of database performance. These may be SQL statements that you have identified as critical to the performance of your database application.


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating