Last Published: September 17, 2021. Any updates to these notes will be
available at www.idera.com/support/productdocuments.
you for using IDERA 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 18.0.0
Optimizer now supports PostgreSQL database management system.
installing IDERA DB Optimizer, verify that your environment meets the following
The following are the minimum hardware requirements:
DB Optimizer is supported on the following operating systems (32- and
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:
For these databases, DB Optimizer supports a subset of this database version’s
Note: DB Optimizer does not access the information, tables, or views
licensed under Oracle's diagnostic pack.
The SQL Server sqlvariant
data type is not currently supported by the Microsoft JDBC driver. If a query
is used to retrieve data from a table that contains a column of the sqlvariant data type, an exception will occur. There are
two workarounds to fix this issue:
Use CAST to type cast the sqlvariant
columns to the data type you want.
Use the jTDS driver to
All IDERA 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 Quick
Start Guide. If you have not yet purchased this product, contact [email protected].
IDERA Product Support
The IDERA Web site is an excellent source for additional product
information, including white papers, articles, and discussion forums. Visit www.idera.com, or click any of the links
below, to find:
If you have a valid maintenance contract with IDERA, the Technical
Support team is available to assist you with any problems you have with our
applications. Our maintenance contract also entitles registered users of IDERA
products to download free software upgrades during the active contract period.
Evaluators receive free technical support for the term of their evaluation (14
To download evaluations of other IDERA products or to learn more
about our company and our products visit us at www.idera.com.