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.
Stream profiling data into central repository
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
The Visual SQL Tuning (VST) diagram displays indexes and constraints on tables and views with table statistics, as well as the joins used in a SQL statement such as Cartesian joins, implied Cartesian joins and many-to-many relationships.
The color-coded Index Analysis feature shows indexes that are used (green), not used (blue), or missing (orange) and offers indexing recommendations for optimum performance.
Visual Diagnostics
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
Stored procedure insights
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.
EDN
