Welcome to Embarcadero® DB Optimizer™ 3.6/XE3.5

Last Updated: February 8, 2013

DB Optimizer Home | DB Optimizer Documentation | Embarcadero Technical Support | www.embarcadero.com


Thank you for using Embarcadero DB Optimizer, an enterprise SQL development and optimization tool that gives database developers and administrators the perfect environment for building the best performing SQL code. This application easily identifies inefficient SQL code and boosts developer productivity by ensuring SQL is right before it becomes a problem in mission-critical applications. DB Optimizer also provides a rich SQL IDE with code completion, real-time error checking, code formatting and sophisticated object validation tools. Lastly, DB Optimizer provides advanced project and data source management tools.

What's New in DB Optimizer 3.6/XE3.5

Connectivity/Data Source

Profiling Updates

Tuning Updates

System Requirements

Hardware Requirements

Supported Operating Systems

Other Requirements

DBMS Support

SQL Execution, Tuning and DBMS Support

SQL Profiling and DBMS Support

Release Notes

Upgrade Notes

Bug Fixes

What's New in DB Optimizer 3.6/XE3.5

Connectivity/Data Source

Profiling

Tuning

System Requirements

Before installing EmbarcaderoŽ DB Optimizer, verify that your environment meets the following requirements.

Hardware Requirements

The following are the minimum hardware requirements:

Supported Operating Systems

DB Optimizer is supported on the following operating systems:

Other Requirements

DB Optimizer requires a Java6 VM to run:

DBMS Support

SQL Execution, Tuning and DBMS Support

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

SQL Profiling and DBMS Support

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

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

Note: DB Optimizer does not access in any way, shape or form any of the information, tables or views licensed under Oracle's diagnostic pack.

Release Notes

Upgrade Notes

Bug Fixes

Bugs Fixed in DB Optimizer 3.6/XE3.5
OPT-2957 ORA-01795: maximum number of expressions in a list is 1000.
OPT-3084 SQL_PARSER to support DB2 LUW v9.7 "round(max(a.miktar), 0) as miktar" statement.
OPT-3455 DB Optimizer 3.5 can't launch on Windows 2008 Server R2
OPT-3537 TS: [Tuning Job] - Error "Could not retrieve the object" returned by tuning job against a DB2 partitioned database

Embarcadero Technologies Technical Support

If you have a valid maintenance contract with Embarcadero Technologies, our Support team will assist you with any problems you have with our applications. Our maintenance contract also entitles registered users of Embarcadero Technologies products to download free software upgrades during the active contract period.

Evaluators receive free technical support for the term of their evaluation. To download evaluations of Embarcadero Technologies products go to the www.embarcadero.com.

To contact Support, go to Support.