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

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

Modify Data

To modify table or view data

  1. Select the table or view you want to modify from the left pane of the Database Explorer window.

  2. Select the Data tab from the bottom of the right pane

  3. Use the button bar at the bottom of the pane to select an editing option.

Note: Not all Views are updateable; a general rule is that any UPDATE, DELETE, or INSERT statement on a join view can be modified if only one underlying base table exists.

 

Related Topics

Copy column names to another window

To facilitate the construction of a SQL statement, copy the selected column names to the SQL Optimizer or SQL Formatter windows.

To copy column names

  1. Select the table or view name displayed on the tree diagram in the left pane [Database Objects] of the Database Explorer window.

  2. Make sure the Column tab is active and select the column names by clicking the left-hand mouse button with the Shift key for multiple selections.

  3. Right-click and select Copy columns to SQL Optimizer to copy the column names to the SQL Optimizer window or select Copy columns to SQL Formatter to copy the column names to the SQL Formatter window.

A new line and a comma separate each column name after the copy.

 

Related Topics

Database Explorer Functions

Below is a list of functions available in the Database Explorer window.

Button or Menu

Function

Edit Menu

image\B_SendToSQLOptimizer.gif

Send to SQL Optimizer

Edit Menu

image\B_CopytoIndexAdvisor.gif

Send to Index Advisor

Edit Menu

image\B_CopyToSQLWorksheet.gif

Copy to SQL Worksheet

Right-click Menu

Copy columns to SQL Optimizer

Right-click Menu

Copy columns to SQL Formatter

Data Tab

Modify Data

 

Related Topics

Related Documents