Welcome to Embarcadero® DB Optimizer™ 3.7/XE4

Last Updated: July 30, 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.7/XE4


This releases focuses on maintenance only, specifically on fixing customer-reported bugs. There are no new or changed features.

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

Additional Resources

Licensing Your Embarcadero Product

Embarcadero Technologies Product Support

Embarcadero Technologies Technical Support

Embarcadero Technologies on the Web

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.7/XE4
OPT-2880 Error - User must have sysadmin or 'VIEW SERVER STATE' permission
OPT-2982 TUNING - Internal error when generating VST for XMLType.
OPT-3149 TS: TUNING - Option to specify elapsed time decimal precision.
OPT-3901 Cannot connect to SQLServer clustered instance with dynaminc ports

Additional Resources

Licensing Your Embarcadero Technologies Product

All Embarcadero Technologies products include a 14-day trial period. To continue using the product without interruption, we recommend that you license it as soon as possible. For information on licensing your product, refer to the DBArtisan Installation Guide. If you have not yet purchased your Embarcadero Technologies product, contact [email protected], or [email protected] for sales in the EMEA region.

Embarcadero Technologies Product Support

The Embarcadero Technologies Web site is an excellent source for additional product information, including white papers, articles, discussion forums, and the Embarcadero Knowledge Base. Visit www.embarcadero.com/support, or click any of the links below, to find:

Embarcadero Technologies Technical Support

If you have a valid maintenance contract with Embarcadero Technologies, the Embarcadero Technical Support team is available to 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 (14 days).

We encourage you to open technical support cases via the Technical Support request form. For additional information about Embarcadero Technologies Technical Support, visit the Support section of our Web site.

Embarcadero Technologies on the Web

To download evaluations of other Embarcadero Technologies products or to learn more about our company and our products visit us at www.embarcadero.com.