What's New in 18.2

For the new features and fixed issues in the latest version of DB Optimizer, see What's New.

System Requirements

Type

PlatformVersion
CPU
  • 1+ GHz

Random Access Memory (RAM)


  • 3 GB
Storage Disk Space
  • 1 GB
Operating SystemMicrosoft Windows
  • 11
  • 10
  • 8.1
  • 8
  • 7
Microsoft Windows Server
  • 2019
  • 2016
  • 2012 R2
  • 2012
  • 2008 SP1
  • 2008 R2
Cloud
  • Amazon Elastic Compute Cloud (EC2)
  • Microsoft Azure Virtual Machine (VM)
n/a
Database (Execution, Tuning, and DBMS) IBM Db2 LUW
  • 11.x*
  • 10.x

JDBC (Execution only)n/a

Microsoft SQL Server
  • 2019*
  • 2017*
  • 2016*
  • 2014 SP2
  • 2014
  • 2012
  • 2008**

Oracle
  • 19c
  • 18c
  • 12c R2
  • 12c
  • 11g R2
  • 11g**
  • 10g**

PostgreSQL
  • 9.6

Sybase ASE
  • 16.x
  • 15.7
Database (Profiling and DBMS) IBM Db2 LUW
  • 11.x*
  • 10.x

Microsoft SQL Server
  • 2019*
  • 2017*
  • 2016
  • 2014 SP2
  • 2014
  • 2012
  • 2008**

Oracle
  • 19c
  • 18c
  • 12c R2
  • 12c
  • 11g R2
  • 11g**
  • 10g**

Sybase ASE
  • 16.x
  • 15.7

* DB Optimizer supports only a subset of features and functions for this database version.

** Support for this version is nearing end of life and may not be available in subsequent DB Optimizer releases. 

Version History

Version 18.1

There are no new features for this product version release.

Version 18.0

  • Supports PostgreSQL

Version 17.1.0

  • Supports Windows Server 2019 and 2012 R2
  • Supports Oracle 11g R2
  • Supports PostgreSQL 9.6
  • Supports SQL Server 2014 SP2

Version 17.0.4

  • Supports SQL Server 2019, Oracle 19c

Version 17.0.3

There are no new features for this product version release.

Version 17.0.2

  • Version number update

Version 17.0.1

  • Continued licensing updates
  • Redesigned components:
    • Main toolbar
    • Data Source tab
    • Project Explorer tab
    • Main window tab mouse options
  • SQL Server enhancements
    • Tuning Statement window includes schemas
    • Profiler detail improved
    • Improved error messages

Version 17.0.0

  • Updated licensing
  • Updated installer
  • Removed Auto-Update and Install New Software from the Help menu

Version 16.6.0

  • Supports Db2 LUW 11 and Sybase 16.x

Version 16.5 (2016+)

  • IDERA rebranding
  • Product licensing changes
  • Supports 64-bit installations
  • Supports Java 1.8 update 91 and Eclipse 4.5.2 

Version 6.3.3 (2016)

  • Supports:
    • Microsoft SQL Server 2012
    • Oracle 12c
    • Sybase ASE 15.7
  • Updated tuning


IDERA |  Products | Purchase | Support |  Resources |  About Us  | Legal