Welcome to Embarcadero® DB Optimizer™ 2.5

Published May 19, 2010

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.

DB Optimizer is supported on the following operating systems:

DB Optimizer will require a Java5 VM to run:

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

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

DB Optimizer should be installed in a different directory than previous versions of DB Optimizer 1.0. If DB Optimizer is installed in the same directory, the following error will result in at application start up: “Unable to read workbench state. Workbench UI layout will be reset.” Additionally, DB Optimizer should be installed in a different directory than previous versions. If a previous version is already installed on your machine, either change the default Workspace or delete all files from the Workspace directory. The Workspace directory location appears whenever you start Optimizer, and can be redefined from this dialog box. If the same Workspace is indicated for the new version as was indicated previously, the following error will result: “Cannot restore workbench layout”. If DB/Optimizer is already running, you can also modify the Workspace directory by choosing File > Switch Workspace > Other from the Main Menu.

What's New in DB Optimizer 2.5

Improvements to Profiling

Improvements to Tuning

What's New in DB Optimizer 2.0

Visual SQL Tuning Diagram

Index Analysis

Expanding Views in the VST Diagram

Profile Details

Licensing

Release Notes

DBMS Support

Important Advisory Notes

Bug Fixes

What's New in DB Optimizer 2.5

Improvements to Profiling

Improvements to Tuning

What's New in DB Optimizer 2.0

Embarcadero DB Optimizer simplifies optimization and development for application developers with many features for improving productivity and reducing code errors. DB Optimizer features fall into two general categories:

The DB Optimizer user interface offers easy to use analysis tools and improves overall productivity. DB Optimizer offers native support for IBM® DB2® for LUW, Oracle®, Microsoft® SQL Server and Sybase® as well as JDBC support for other DBMS.

Visual SQL Tuning Diagram

Index Analysis

Expanding Views in the VST Diagram

Profile Details

Licensing

Release Notes

DBMS Support

Important Advisory Notes

Bug Fixes

Use your browser Find feature to locate a particular bug number or click a link below to see the issues addressed in a specific build.

Bugs Fixed in DB Optimizer 2.5

Bugs Fixed in DB Optimizer 2.0.1

Bugs Fixed in DB Optimizer 2.0

Bugs Fixed in Embarcadero DB Optimizer 2.5
OPT-1236 DB Optimizer no longer errors on Vista when completing the bind variable and collapsing the SQL Text.
OPT-2038 Discover data sources now finds any SQL Server data source on the network.
OPT-2148 The system is now more reliable when automatically detecting connections previously defined.
OPT-2244 The system no longer creates false cartesian joins on the Visual SQL Tuning diagram for nested select statements.
OPT-2265 The system now usess the right Oracle schema when tuning from profiler.
OPT-2309 The on-demand cache is now working correctly in all schema configurations of the Oracle E-Business Suite.
OPT-2396 The system no longer errors when running or profiling a stored procedure with user-defined datatype parameters.
Bugs Fixed in Embarcadero DB Optimizer 2.0.1
OPT-1784 When using All-Access, Database platform licenses are now correctly checked out upon launch of the Eclipse-based version of DB Optimizer.
OPT-1940 Tuning can now be initiated from the command line.
OPT-1987 On Sybase indexes are now suggested for statements where the schema is not specified.
OPT-2001 The analysis and the EXPLAIN PLAN for generated cases now correctly works with the SYBASE cp936 character set.
OPT-2045 Profiling can now be initiated from the command line.
Bugs Fixed in Embarcadero DB Optimizer 2.0
OPT-1622 From the command line the profiling duration can now be increased to more than 60 seconds.
OPT-1675 The Tuner can now properly extract SQL from Procedures (Sybase).

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. To license your product, use the License Request Wizard found in the Help menu of your respective product. If you have not yet purchased your Embarcadero Technologies product, contact sales@embarcadero.com, or uk.sales@embarcadero.com 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, FAQs, discussion groups, and the Embarcadero KnowledgeBase. Go to www.embarcadero.com/resources, 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 at the Embarcadero Technologies Web site. For additional information about Embarcadero Technologies Technical Support, go to the Support page on 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.