Welcome to Embarcadero® DB Optimizer™ 3.8/XE5

Last Updated: Jan. 31, 2014

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.8/XE5

New DBMS Version Support

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

Additional Resources

Licensing Your Embarcadero Product

Embarcadero Technologies Product Support

Embarcadero Technologies Technical Support

Embarcadero Technologies on the Web

What's New in DB Optimizer 3.8/XE5

New DBMS Version Support

This release introduces execution, tuning, and profiling support for the following DBMS versions:

• Oracle 12c
• SQL Server 2012
• Sybase ASE 15.7.

Tuning Updates

• SQL Server hints - DB Optimizer tuning now supports the IGNORE_NONCLUSTERED_COLUMNSTORE_INDEX and SPATIAL_WINDOW_MAX_CELLS hints.

  DB Optimizer tuning no longer supports the FASTFIRSTROW hint.

• Oracle 12c hints - DB Optimizer tuning now supports the GATHER_OPTIMIZER_STATISTICS, NO_GATHER_OPTIMIZER_STATISTICS , NO_PQ_CONCURRENT_UNION, NO_PQ_SKEW, NO_USE_CUBE, PQ_CONCURRENT_UNION, PQ_FILTER, PQ_SKEW, and USE_CUBE hints.
• Oracle 11g hints - DB Optimizer tuning now supports the APPEND_VALUES, CHANGE_DUPKEY_ERROR_INDEX, and RETRY_ON_ROW_CHANGE hints.

System Requirements

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

Hardware Requirements

The following are the minimum hardware requirements:

• Pentium 4-Level Processor
• 1 GB of memory
• 1 GB of disk space
• 1024 x 768 screen resolution

Supported Operating Systems

DB Optimizer is supported on the following operating systems:

• Microsoft Windows 8
• Microsoft Windows 7, 32 and 64 bit
• Microsoft Windows Server 2008, 32 and 64 bit
• Microsoft Windows Vista, 32 and 64 bit
• Microsoft Windows XP, 32 and 64 bit
• Microsoft Windows 2003
• Linux, x86-32, GTK 2
• Red Hat Enterprise Linux 5.0
• SuSe Linux Enterprise Server 10

Other Requirements

DB Optimizer requires a Java6 VM to run:

• Windows XP/Vista/2003 Sun Java 2 Standard Edition 6 Update 45 for Microsoft Windows
• Linux: Sun Java 2 Standard Edition 6 Update 27 for Linux x86
• DB Optimizer can be installed as a standalone application (RCP installation) or as an Eclipse plug-in (plug-in installation).
• The Eclipse plug-in version of DB Optimizer requires Eclipse version 3.6 or higher and Sun Java Standard Edition 6 (with the Windows-specific or Linux-specific Update specified in the first two points) in addition to regular system requirements. Before installing the plug-in version of DB Optimizer, ensure that Eclipse and Java are installed on your machine. You can download Eclipse from the following Web site: www.eclipse.org/downloads.

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:

• Oracle (9i - 12c)
• Sybase (12.5 - 15.7)
• IBM DB2 for LUW (8.0 - 9.x)
• MS SQL Server (2000, 2005, 2008 R2, 2012)
• JDBC (execution only)

SQL Profiling and DBMS Support

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

• Oracle (9i - 12c)
• Sybase (12.5 - 15.7)
• IBM DB2 for LUW (8.2 - 9.x)
• MS SQL Server (*2000 SP3, 2005, 2008 R2, 2012)

* 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

• DB Optimizer should be installed in a different directory than previous versions of DB Optimizer. 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.
• 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.

• We strongly suggest selecting a new workspace when upgrading from a previous version of DB Optimizer.
• Saved profiling and tuning session files (.oar) created using previous versions of DB Optimizer are not compatible with current versions. You can however have more than one version of DB Optimizer installed on the same system. To read old .oar files, run the older version of DB Optimizer.

Bug Fixes

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:

• Documentation
• Online Demos
• Technical Articles and White Papers
• Discussion Forums

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.

comments: [email protected]