Quest 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. Test Run SQL Alternatives |
Quest 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. Test Run SQL Alternatives |
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.
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
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
Click
Review the following for additional information:
Select Connection | Description |
Connection |
Click Tip: Click |
Select Schema and SQLID | Description |
Schema |
Click |
SQLID |
Click |
© ALL RIGHTS RESERVED. Feedback Termini di utilizzo Privacy Cookie Preference Center