SQL Profiling

• Graphical visualization of wait-time analysis to easily pinpoint the SQL causing poor database performance
• Continuous profiling monitors an entire datasource within a configurable span of time
• Explain plans for a better understanding of how SQL will be executed and the performance costs
• All data and metadata pertaining to a profile session can be saved as a single entity into an archive file so profiles can be shared.

SQL Tuning

• Batch tuning of DML statements, stored routines, and entire SQL files
• Case Generation is used to generate all possible cases and find the best alternative to a given SQL statement including SQL rewrites and hint injection

Reporting

• Profile chart shows the CPU, I/O, and other wait activity over the course of the profile session
• Execution statistics provide detailed information about the profiled SQL and wait categories
• Explain plans for each SQL statement can be computed on demand in the Execution Statistics table

SQL Editing

• Includes a powerful SQL IDE geared to the needs of application developers
• Real-time quick fixes flag and correct inefficient SQL automatically
• SQL code assist and real-time SQL syntax validation
• Project-level SQL file cataloging and search features

General

• Full support for DB2 for LUW, Oracle, SQL Server and Sybase ASE.
• Full Unicode support
• Command line interface