SQL Optimizer for DB2 ZOS 5.6 - User Guide

Product Licensing

To register the trial or production version

1. Select Help | Licensing.
2. Enter your Authorization key.
3. Enter your site message if you have a Production key.
4. Click Apply.

Additional Resources

Toad World

Visit other Toad Communities. Find DBMS and SQL knowledge, find software downloads, and find answers to your database questions. Click here to go to Toad World or follow the instructions below.

To go to Toad World

Click Help and select Go to Toad World.

Search

SQL Optimizer allows you to conduct searches in Toad World, Help, and Google.

To conduct a search

1. Enter your search item in the Search field at the top right..
2. Select an option from the list.

SQL Operations

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:

BTBSCAN

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.