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

Object Extractor Tutorial

Tutorials > Object Extractor Tutorial

The Object Extractor extracts the DDL for creating database objects from the database. As an option, object dependencies can also be retrieved ordering them by the lowest dependencies first.

Extract DDL

  1. Click image\B_ObjectExtractor.gif.

  2. Select the objects to extract from the left pane [Select objects to be extracted]. Click Add to add the selected objects to the right pane [Objects to extract].

  3. Click Extract DDL to display the DDL script on the bottom pane. Or, click Extract to file to save the DDL script directly to a file.

  4. In the Extraction Criteria window, select options to generate the DDL script.

  5. Click OK.

  6. Extraction preferences can be changed by selecting File | Preferences and selecting the DDL tab.

 

Related Topic

Object_Extractor_Overview

SQL Worksheet Tutorial

Tutorials > SQL Worksheet Tutorial

The SQL Worksheet enables you to create and execute Transact-SQL code, database objects and SQL commands.

Executing SQL or Transact-SQL

  1. Click image\B_SQLWorksheet.gif.

  2. Enter your SQL statement or Transact-SQL code in the Editor pane.

  3. Click image\B_Execute.gif.

  4. Use the drop down field at the top of the Editor pane to review and reuse any code executed in the SQL Worksheet during your session.

 

Related Topic

SQL_Worksheet_Overview

Code Finder Tutorial

Tutorials > Code Finder Tutorial

The Code Finder identifies database objects and files that contain specific text.

Search for Text

  1. Click image\B_CodeFinder.gif.

  2. Enter the text string to search for in the Text field in the Search Criteria section.

  3. Use the Quick Find, Database Objects and Directory/Files tabs to select what to search. You can search in database objects (Tables, Views, Procedures, Triggers, Rules, Defaults, etc.) and/or files.

  4. Click Search.

  5. Double-click an item in the Search Result pane to open the matched database object or file in the SQL Worksheet.

 

Related Topic

Code Finder Overview

SQL Formatter Tutorial

Tutorials > SQL Formatter Tutorial

The SQL Formatter formats SQL statements, verifies syntax, and color-codes variables, invalid field or table names, optimization forces and comments. The use of indenting and highlighting gives SQL statements a standard of formatting that is easy to read.

To format a SQL statement

  1. Click image\B_SQLFormatter.gif.

  2. After entering a SQL statement in the left pane of the window, click image\B_Format.gif.

Comments, bind variables, optimizer forces, invalid column or table names, and variables are highlighted in different colors. If there is a syntax error, an error message from Adaptive Server displays.

 

Related Topic

SQL Formatter Overview

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating