Compare the top database query optimization tools

IDERA is focused on delivering the industry’s most complete solution for database optimization. DB Optimizer offers extensive capabilities for single- and multi-platform database performance optimization, including a unique visual tuning diagram feature.

Compare, side by side, the features and functionalities of some of the database optimization tools the market has to offer. Download a free trial of DB Optimizer today!

IDERA
DB Optimizer
SQL Sentry
Plan Explorer
Quest SQL
Optimizer
SQL Server
Management Studio
Oracle Tuning
& Diagnostic Packs
Capture workload profile by scanning database for SQL execution activity for time period
 
 
 
add-on add-on
SQL tuning session via manual typing within SQL editor or loading a text file
 
 
 
 
 
SQL tuning session by scanning database for current SQL execution activity
 
 
 
 
 
Display SQL statement's database execution plan
 
 
 
 
 
Automatically generate SQL rewrites to potentially improve run time statistics
 
 
 
   
User can specify rules for automatic SQL rewrite allowances and exclusions
 
 
 
   
SQL rewrites can generate candidates using native database optimizer hints
 
 
 
 
 
SQL rewrites can generate candidates by transforming the SQL syntax itself
 
 
 
   
Recommend missing indexes which would improve execution plan
 
 
 
 
 
Test SQL load scalability by running multiple concurrent sessions for SQL statement
 
 
 
   
Visual tuning diagram that clarifies the data context, data relationships, data sizes and join relationships
 
   
 
 
Supports Oracle, SQL Server, Db2 and Sybase
 
 
 
   

With a rich set of features, IDERA DB Optimizer enables database professionals to easily improve the performance of their SQL code and tune SQL like a professional. It can capture workload profiles by scanning databases for SQL execution activity for a time period. Also, it can automatically generate SQL rewrites to improve potentially run time statistics. Users can specify rules for automatic SQL rewrite allowances and exclusions.

DB Optimizer is a leading SQL tuning tool. It provides SQL rewrites that can generate candidates by transforming the SQL syntax itself. It can test SQL load scalability by running multiple concurrent sessions for SQL statements. Also, it provides a visual tuning diagram that clarifies the data context, data relationships, data sizes and join relationships. And it supports Oracle Database, Microsoft SQL Server, IBM Db2 and SAP Sybase.

DB Optimizer helps database administrators to tune and profile SQL code across database platforms. Unlike its competition, it provides automated SQL tuning and performance optimization suggestions with color-coded index analysis, database profiling of wait-time analysis for a single stored routine or an entire data source, SQL stress load testing to simulate a production environment with parallel users and executions over a specific period of time or execution cycle, and review of SQL execution and performance costs using explain plans.

Download a free, full function 14 day trial of IDERA DB Optimizer right now and discover for yourself how it can make your life simpler, save your company time and money, and help make you a rock star database professional in your organization.

Download This Comparison
Try DB Optimizer FREE for 14 days

Tune SQL like a pro with DB Optimizer, IDERA's SQL database optimization tool, which offers performance optimization suggestions, visual tuning diagrams and more.



Start for Free
Share This
Contact IDERA:
+1 (713) 523-4433