DB Optimizer is an easy-to-use, easy to install SQL profiling and tuning IDE that supports DB2 for LUW, Oracle, SQL Server and Sybase. DB Optimizer helps eliminate performance bottlenecks by identifying data intensive or frequently executed queries, focusing on specific SQL statements through query statistics (CPU, I/O, wait times), and fine-tuning problematic statements.
DB Optimizer 2.0 takes SQL tuning beyond standard hint injections and SQL rewrites and offers innovative, new features for faster and more detailed SQL tuning and analysis. New graphical tools like the Index Analysis feature let DBAs and developers fully examine SQL execution paths to better understand which indexes are used, not used, or missing. If an index is missing, DB Optimizer will offer indexing recommendations for optimum performance. The Visual SQL Tuning (VST) diagram displays indexes and constraints on tables and views, as well as the joins used in a SQL statement. This innovative visual format quickly reveals opportunities to tune the SQL or schema and enhance overall database performance.
SQL Visual Tuning (VST) Diagrams
The Visual SQL Tuning (VST) diagram, which can be displayed in either Summary Mode or Detail Mode, displays indexes and constraints on tables and views, as well as the joins used in a SQL statement such as Cartesian joins, implied Cartesian joins and many-to-many relationships.
Index Analysis
The color-coded Index Analysis feature let DBAs and developers fully examine SQL execution paths to better understand which indexes are used (green), not used (blue), or missing (orange). If an index is missing, DB Optimizer will offer indexing recommendations for optimum performance.
Load Editor
SQL stress testing simulates a number of parallel users and executions over a specific period of time or execution cycle
Profiling Session Details
Profiling Details of the SQL Profiler have been expanded to show Session Details for Sybase, and SQL Server and the SQL that ran in the selected session for Sybase, SQL Server, and DB2.
