Published December 3, 2009
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:
What's New in DB Optimizer 2.0
Expanding Views in the VST Diagram
Release Notes
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:
Visual SQL Tuning diagram that lets both developers and DBAs quickly analyze indexes and constraints on tables and views and understands joins used in a SQL statement.
Color-coded Index Analysis feature displays all indexes in the execution plan with vital information such as which indexes are maximizing performance, suggests missing indexes, and indicates which indexes are used by the execution plan and which are not.
Expanding Views in the VST Diagram
View and sub-views can now be expanded to show the contents within them, including the tables and the indexes on those tables. Views can now be expanded in both Project Explorer and the Visual SQL Tuning diagram.
Profiling Details of the SQL Profiler have been expanded to show Session Details for Sybase and SQL Server, and the SQL that ran in the selected session for Sybase, SQL Server, and DB2.
Platform licenses are now checked out on demand, based on connected platforms.
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.0.1
Bugs Fixed in DB Optimizer 2.0
| Bugs Fixed in Embarcadero DB Optimizer 2.0.1 | ||
|---|---|---|
| OPT-2045 | Profiling can now be initiated from the command line. | |
| OPT-1940 | Tuning can now be initiated from the command line. | |
| Bugs Fixed in Embarcadero DB Optimizer 2.0 | ||
|---|---|---|
| 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 [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, 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.