立即与支持人员聊天
与支持团队交流

SQL Optimizer for DB2 ZOS 5.6.2 - User Guide

Welcome Optimize SQL Options Tutorial About us Third-party contributions Copyright

Welcome

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

 

About SQL Optimizer

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

 

About Product Improvement Program

To prioritize enhancements in future releases, SQL Optimizer for DB2 z/OS collects data about the use of its different features, and periodically, this data is communicated back to us. Initially, this usage data includes an IP address. Upon its receipt at a temporary server in the U.S.A., the IP address is removed, and then the anonymous data is aggregated before it is sent to our servers in California. Our product team analyses the aggregated data to understand our user community’s preferences and common practices. This analysis influences our future releases. Click here for more information on the data we collect and on our privacy policy.

  • No personal information is collected
  • You can stop participating at any time

To initiate participation in Product Improvement Program

Select Help | Product Improvement Program and select Yes, I want to participate

To cancel participation in Product Improvement Program

Select Help | Product Improvement Program and select No, thank you

Connections

Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To select a connection

  1. Select the SQL Details tab in the main window.
  2. Click

  3. Review the following for additional information:

    Select Connection Description

    Connection

    Click to select a previously created connection.

    Tip: Click to open the Connection Manager to create a new connection. Connect to the Database

    Select Schema and SQLID Description

    Schema

    Click to select a schema for the connection.

    SQLID

    Click to select your SQLID.

 

Related Topics

Tutorial: SQL Optimizer

自助服务工具
知识库
通知和警报
产品支持
下载软件
技术说明文件
用户论坛
视频教程
RSS订阅源
联系我们
获得许可 帮助
技术支持
查看全部
相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级