Call us on: +44 (0)1364 654100
Idera DB Optimizer 2016+ boxshot.

Idera DB Optimizer 2016+ [Commercial - Update Subscription]

Published By:  Embarcadero

Product Variants



(Ex. VAT)



Commercial - Update Subscription (1-Year) (All Platforms) (1) Concurrent User - Electronic *UK ONLY* Windows   £282.72   Email   Add to Basket
Commercial - Update Subscription (1-Year) (All Platforms) (1) Network Named User - Electronic *UK ONLY* Windows   £141.86   Email   Add to Basket
Commercial - Update Subscription (1-Year) (All Platforms) (1) Workstation - Electronic *UK ONLY* Windows   £141.86   Email   Add to Basket
Commercial - Update Subscription (1-Year) (Single Platform) (1) Concurrent User - Electronic *UK ONLY* Windows   £188.81   Email   Add to Basket
Commercial - Update Subscription (1-Year) (Single Platform) (1) Network Named User - Electronic *UK ONLY* Windows   £93.91   Email   Add to Basket
Commercial - Update Subscription (1-Year) (Single Platform) (1) Workstation - Electronic *UK ONLY* Windows   £93.91   Email   Add to Basket

Other product variants may be available, please contact us or request a call back if you cannot see what you are looking for.


Idera DB Optimizer is an automated SQL optimization tool that maximizes database and application performance by quickly discovering, diagnosing, and optimizing poor-performing SQL code. DB Optimizer empowers DBAs and database developers to eliminate performance bottlenecks by graphically profiling key metrics inside the database, relating resource utilization to specific queries, and helping to visually tune problematic SQL.

Multi-platform Support

Supports all major DBMSs from a single interface. Ability to use the tools on all supported platforms from a single license.

Embarcadero AppWave

Enables centralized license management and tool deployment.


Offers full Unicode support.

Command-Line API

Launch profiling and tuning sessions remotely

Profile Chart

Shows the CPU, I/O, and other wait activity over the course of the session. Zoom in/out functionality available. (Wait categories vary by platform.)

Execution Statistics

Detailed information on the profiled SQL and wait categories, broken down by SQL statements, events, and sessions.

Profiling Details

Drill down into the execution details for any given statement, including the SQL text, events, sessions, child cursors, blockers, procedures, and SQL details.

Predicate Analysis

SQL statements are rolled up for a true analysis of the number of executions in real-time.

Explain Plans

The Explain Plan for each SQL statement can be computed on demand via a context menu item in the Execution Statistics table. The Explain Plan appears in a separate view as a tree with columns and collapsible column groups.


Highlights a time interval in the profile chart to instantly change the data displayed, making it easier to see the details.


Identify and diagnose performance bottlenecks and problematic SQL without agents or placing a significant load on the target database.

Load Editor

SQL stress testing simulates a number of parallel users and executions over a specific period of time or execution cycle.

Continuous Profiling

Continuously profile an entire data source within a configurable span of time.

Profiling a Stored Routine

When fine tuning or testing SQL, profile the execution of a single stored routine when profiling an entire data source is not desired.

Live Data

Show data in real-time while profiling is in progress.

Sharing Profile Sessions

All data and metadata pertaining to a profile session can be saved as a single entity into an archive file. Profiles can be shared across multiple workspaces and machines for collaboration purposes.

Tuning Job

Create and run tuning jobs for a single statement or batch of statements.

Batch Tuning

Tune all DML statements, stored routines, and entire SQL files.

Case Generation

SQL rewrites and hint injection are used to generate all possible cases and find the best alternative to a given SQL statement.

SQL Rewrites

SQL rewrites are suggested as part of the case generation in the SQL tuner. SQL rewrites are also suggested as you type in the SQL IDE.

Hint Injection

Customize the subset of hints to be considered for hint injection and alternative execution paths.

Cost Generation

Display the explain plan cost for each original statement and each generated case to give the user the expected cost given the execution path utilized by the database.

Visual SQL Tuning

The Visual SQL Tuning (VST) diagram 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, with table statistics

Index Analysis

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.

Execution Statistics

Run the SQL with alternative execution paths to discover the fastest running SQL statement, and apply the change at the click of a button.

Textual Comparison of Cases

A visual diff viewer helps the user spot the textual differences between any two SQL statements.

File Capture

Save an entire profiling session to a file for future analysis and reference or to share with others

Repository Capture

Stream profiling data into a central repository for your open session.

Shopping Basket
    0 Item(s)

    View and amend your basket
    ISV Royalty Licensing