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


Introduction to SQL Optimizer for SAP ASE

Quest SQL Optimizer for SAP ASE enables IT professionals to analyze, predict, preempt, diagnose, optimize and manage performance changes to ensure that mission-critical business applications run optimally. It maximizes application performance by focusing on those database factors that contribute up to 90% of performance problems: SQL statements, indexes, and database changes. Quest SQL Optimizer for SAP ASE allows for the management and prediction of performance changes; therefore, changes that will affect the database environment can be managed with the highest degree of certainty. It is the optimal performance change management solution for production and quality assurance teams.

SQL Optimizer has the following main modules and functionality:

Performance Diagnostics

Performance Optimization

Performance Management

Database Administration




New in This Release

Quest SQL Optimizer for SAP® ASE 3.9.1 is a patch release containing bug fixes and enhancements.

Database Versions Supported

Adaptive Server 15.0 or later is supported.


Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating