Introduction to SQL Optimizer for Sybase ASE

Introduction to Quest 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

• SQL Inspector
• SQL Collector for Monitor Server
• SQL Scanner
• Performance Monitor

Performance Optimization

• SQL Optimizer
• Index Advisor
• Abstract Plan Manager

Performance Management

• Configuration Analyzer
• Migration Analyzer
• Index Impact Analyzer
• Index Usage Analyzer

Database Administration

• Database Explorer
• Object Extractor
• SQL Worksheet

Development

• SQL Formatter
• Code Finder

Functionality

• User-Defined Temp Table
• SQL History
• SQL Repository
• Editor Functions
• Activity Log