Chat now with support
Chat with Support

We are currently experiencing issues on our phone support and are working diligently to restore services. For support, please sign in and create a case or email for assistance

SQL Optimizer for DB2 ZOS 5.5.1 - User Guide

Welcome Optimize SQL Options Tutorial About us Copyright

SQL Optimization Workflow

The SQL optimization workflow ensures that your SQL statements perform optimally in your database environment.

Procedure Description
Optimize SQL Statements

The SQL Optimizer uses artificial intelligence to generate alternatives with unique execution plans for problematic SQL statements. SQL Optimizer generates the alternatives by analyzing SQL statement syntax and database structure. Optimize SQL Statements

Test Run SQL

The Test Run SQL function tests the performance of each alternative SQL Optimizer generates. This provides execution times for each alternative to determine the best statement for your database environment. Test Run SQL Alternatives

Compare SQL Alternatives

The Compare feature displays details for two SQL statements side-by-side. You can compare an alternative to the original SQL statement or compare two alternatives.

Generate Reports

The Report feature creates a SQL resolution report after you complete the optimization process.


Create Support Bundles

The Support Bundle provides any easy way for you to contact Quest technical support to report a problem or ask a question. It includes information about each module of the application and your local computer; and can be used to help troubleshoot problems.  

To create a support bundle

  1. Select Help | Support Bundle.

  2. Complete the Contact and Problem Details sections.


Join the SQL Optimizer Community

The SQL Optimizer for DB2 z/OS Community is available for you to find the latest information about SQL Optimizer. By joining the community, you can participate in the beta program, communicate with the development team and other users in the discussion forums, and read blog entries. Click Toad for DB2 community to join the community or follow the instructions below to access the community from SQL Optimizer.

To access the community

Select the Community tab in the main window.

Note: You need a connection to the Internet to access most community content.


Related Topic

Register SQL Optimizer

To register SQL Optimizer

  1. Select Help | Licensing.

  2. Review the following for additional information:

    Authorization key Enter the license key for SQL Optimizer.
    Site message Enter the site message included with the license key.


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating