Features and Benefits

Quest SQL Optimizer for Sybase

Key Features

• Identifies problematic SQL statements in database applications
• Diagnoses SQL related performance bottlenecks with visual analysis of Adaptive Server’s performance metrics
• Generates every possible SQL alternative to automatically locate the most-efficient SQL
• Proposes new index scenarios for a SQL statement and identifies performance effects on indexes in the database system
• Analyzes the effect on performance when changing Adaptive Server configuration parameters
• Preempts performance degradation before deploying applications to production or upgrading Adaptive Server
• Identifies unused indexes in the database to free up space and decrease maintenance
• Integrates DDL generation for multiple SQL statements and an interface that allows DBAs to create scripts and execute commands

Key Benefits

• Ensures reliable database performance
• Maximize performance through SQL and database optimization
• Ensures successful Adaptive Server upgrades
• Preempts performance problems before deploying applications into production
• Improves productivity of QA and production teams
• Provides a performance assurance strategy across the application lifecycle