Dell™ SQL Optimizer for IBM® DB2® z/OS® ensures optimal SQL performance by generating alternatives and testing SQL for maximum application performance.
SQL Optimizer analyzes your SQL statements and generates alternatives for improving performance. It can test these alternatives to identify the best SQL statement for your database environment. Optimizing SQL consists of the following functions:
| Functions | Description |
|
Optimize SQL Statement |
SQL Optimizer uses an Artificial Intelligence engine to execute SQL syntax rules that produce semantically equivalent SQL statement alternatives. |
|
Test Run SQL Alternatives |
SQL Optimizer executes statement alternatives to view their execution statistics. This provides execution times for identifying the best SQL statement for your database environment. See Test Run SQL Alternatives for more information. |
Scan a buffer table.
A buffer table construct contains two nodes: a BTBSCAN node and a buffer table node. The buffer table scan is the only way to access a buffer table.
Use a correlated subquery for access.
The CORSUB operation provides access by a correlated subquery.
Perform a DELETE WHERE CURRENT OF CURSOR operation.
