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

Code Finder Functions

Below is a list of available functions within the Code Finder window.

Menu

Function

  Search

 

Abort

 

Extract to File

 

New Search

Right-click Menu

Open in SQL Worksheet

Right-click Menu

Save

 

Related Topics

Extract Object DDL to File

Open Database Object or File in SQL Worksheet

Save Search Results

Code Finder Overview

Code Finder Window

Regular Expression

Object Extractor

Object Extractor Overview

The Object Extractor allows the retrieval of the DDL text for creating the database objects. You can also retrieve the DDL for the object dependencies ordered by the lowest dependencies first.

 

Related Topics

Object Extractor Window

The Object Extractor window has the following panes and buttons:

Select objects to be extracted [left pane]

Displays a tree view of all database objects available for extraction.

Objects to extract [right pane]

Displays the list of selected objects to be extracted, duplicate objects cannot be added. A checkbox is available to include extraction of the object’s dependents.

DDL [bottom pane]

Displays the DDL script when Extract DDL is selected.

Buttons

Button Function

Extract DDL

Extract the DDL of the selected object(s) to the bottom pane.

Extract to file

Extract the DDL of the selected object(s) directly to a file.

Abort

Abort the extraction process.

 

Related Topics

Related Documents