DB Optimizer

Visual SQL tuning and profiling for performance and reliability

DB Optimizer is a database optimization tool that maximizes database and application performance, reliability, and availability by profiling, tuning, and load testing SQL code.

bubble

DB Optimizer Supported Database Platforms

DB Optimizer supports the following platforms:

SQL Execution, Tuning and DBMS Support
SQL execution and SQL tuning with DB Optimizer is supported on the following DBMS platforms and versions:

  • Oracle (9i - 11g)
  • Sybase ASE (12.5 - 15.x)
  • IBM DB2 for LUW (8.0 - 9.x)
  • MS SQL Server (2000, 2005, 2008 R2)
  • JDBC (execution only)

SQL Profiling and DBMS Support
SQL profiling with DB Optimizer is supported on the following DBMS platforms and versions:

  • Oracle (9i - 11g)
  • Sybase ASE (12.5.0.3 - 15.x)
  • IBM DB2 for LUW (8.2 - 9.x)
  • MS SQL Server (*2000 SP3, 2005, 2008 R2)

* On Microsoft SQL Server 2000, the Profiling feature is only supported if Service Pack 3 (SP3) is installed.

Note: DB Optimizer does not access the information, tables or views licensed under Oracle's diagnostic pack.