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

Database Explorer Overview

Database Explorer > Database Explorer Overview

The Database Explorer facilitates the viewing of database objects within the database server. It saves you from having to use specific SQL commands to access information from the data dictionary, making it an easy job to obtain the most up-to-date database information, simply by point and click.

 

Related Topics

Database Explorer Window

Database Explorer > Database Explorer Window

The Database Explorer window is divided into two sections:

Left Pane (Database Objects)

Displays a tree diagram of the database objects.

Right Pane (Object Information)

Displays relevant information of the selected database object.

 

Related Topics

Database Explorer Privileges

Database Explorer > Database Explorer Privileges

Your user privileges within the database server are reflected in Database Explorer. If you do not have access to a database, the database icon will be dimmed and no sub-items will be available.

When you expand the first component of the tree you will notice that the database icon is either gray or green, to indicate which databases you have access to.

Access to the system catalog table, syscomments, is needed to view SQL text for procedures, triggers, views, default and rules objects. If you do not have access to the syscomments system table, a message "SQL Text unavailable" will be presented in the Text tab.

Note: For Adaptive Server, you are able to access the syscomments system catalog table by turning the "select on syscomments.text" parameter on, use the command:

sp_configure "select on syscomments.text", 1

 

Related Topics

Open Database Explorer

Database Explorer > Open Database Explorer

To open the Database Explorer window

Click image\B_DatabaseExplorer.gif.

The tree diagram displays database objects in the form of a tree layout. The behavior of this module is very similar to Windows-based applications. To expand or collapse the associated list of sub-items, click each branch name. To display the details of a database object, click the object name and the corresponding information will be displayed in the right pane of the window.

The Object Information displays information about the selected database object. By clicking a tab located at the bottom of the right pane, related details about the database object are displayed.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating