DB Optimizer

IDERADatabase Optimization Tools
Version 19.1.1 (Jun 25, 2026)

Tuning and optimizing SQL code across multiple database platforms.

  • Automates SQL query tuning for major DBMS platforms.
  • Profiles SQL performance with visual diagnostics and metrics.
  • Offers load simulation and continuous profiling for testing.
IDERA logo

Prices from:

Loading...
Available asOur Price
DB Optimizer MultiplatformLoading
DB Optimizer for DB2Loading
DB Optimizer for OracleLoading
DB Optimizer for SQL ServerLoading
DB Optimizer for SybaseLoading
Also available in
DB PowerStudio Developer EditionLoading
DB PowerStudio DBA EditionLoading
Need help choosing? See How to Buy
SQL profiling and tuning IDE.
DB Optimizer accelerates database performance by automating the discovery, diagnosis, and optimization of inefficient SQL queries. It provides a unified interface for tuning across popular relational databases, enabling developers and administrators to visually analyze and improve SQL execution with profiling and graphical tools.

Multi-Platform SQL Tuning Interface

Manage SQL tuning across Microsoft SQL Server, Oracle, IBM Db2 LUW, SAP Sybase ASE, PostgreSQL, Pivotal Greenplum, and Amazon Redshift from a single unified GUI and license, simplifying cross-platform database optimization.

SQL Rewrites and Hint Injection

Automatically generates SQL rewrite suggestions and applies customized hint injection to explore alternative execution paths, enhancing query performance through informed case generation.

Explain Plan Cost Evaluation

Displays the execution cost for original and alternative SQL statements, allowing users to compare and identify more efficient query execution plans.

Visual SQL Tuning Diagram

Illustrates indexes, constraints, join types, and table statistics visually, helping to detect inefficient joins and relationships such as Cartesian joins and many-to-many connections.

Index Usage Analysis and Recommendations

Color-codes indexes based on usage to show effective, unused, or missing indexes, and provides recommendations to optimize indexing strategies for performance improvements.

Execution Statistics and Performance Testing

Executes SQL under different plans to find the fastest query version and applies improvements easily through the interface, complemented by load testing simulations for pre-production validation.

Continuous Profiling and Sampling

Profiles entire data sources or specific stored routines over time without imposing agents or heavy load on the database, capturing real-time data and resource utilization metrics.

Profile Session Management and Collaboration

Allows saving profiling sessions with metadata into archives for sharing across teams and machines, offering detailed charts and drill-down views for analysis of CPU, I/O, blocking, and wait events.

Command Line API and Unicode Support

Enables launching profiling and tuning sessions remotely via API calls while supporting full Unicode character sets throughout the application for internationalized environments.

Product Compatibility

Review the details below to ensure this product is supported within your environment.

Database Support

  • Microsoft SQL Server
  • Oracle

Operating System

  • Windows Desktop
  • Windows Server

Windows Desktop Version

  • Windows 11
  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7

Windows Server Version

  • Windows Server 2022
  • Windows Server 2019
  • Windows Server 2016
  • Windows Server 2012
  • Windows Server 2008