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

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

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

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

Related Documents