Chat now with support
Chat with Support

SQL Optimizer for DB2 ZOS 5.6.1 - Installation Guide

About Quest SQL Optimizer for IBM DB2 z/OS

Quest SQL Optimizer for IBM DB2 z/OS ensures optimal SQL performance by generating alternatives and testing SQL for maximum application performance.

Optimize SQL

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. Test Run SQL Alternatives

 

Related Documents