Return
-
Title
What is new SQL Optimizer for Oracle version 9.1? -
Description
This article lists the new items in SQL Optimizer version 9.1. -
Resolution
New Features
This release of SQL Optimizer includes the following new features and enhancements.
Optimize SQL
Test Run Different Bind Values
You can now test run SQL alternatives using a number of different bind values. After optimizing a SQL statement that contains one or more bind variables, you can use the Test Run Different Bind Values tab to select SQL and enter multiple bind values to test run against.
General
Setting Bind Variables
To streamline the Setting Bind Variables dialog, the form no longer includes a Null column.
To indicate NULL, leave the Variable Value field blank.See the Release Notes for a more complete list of issues resolved and enhancements implemented in this release.