Tchater maintenant avec le support
Tchattez avec un ingénieur du support

SQL Optimizer for DB2 ZOS 5.6.2 - User Guide

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

XIXSCAN

Access and scan an XML index.

This operation returns DOCID and NODWID pairs.

 

Optimize SQL

The Optimize SQL function analyzes the input SQL statement and uses an Artificial Intelligence Engine to produce a group of semantically equivalent versions of the statement, known as SQL alternatives. You can then test run these alternatives in the SQL Optimizer window to determine the best-performing version of the SQL.

Note: The Intelligence Level setting you select affects the duration of the optimization process and the number of alternatives SQL Optimizer generates.

About Optimizing SQL

The Optimize SQL function analyzes the input SQL statement and uses an Artificial Intelligence Engine to produce a group of semantically equivalent versions of the statement, known as SQL alternatives. You can then test run these alternatives in the SQL Optimizer window to determine the best-performing version of the SQL.

Note: The Intelligence Level setting you select affects the duration of the optimization process and the number of alternatives SQL Optimizer generates.

Create Optimize SQL Sessions

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

To create a new session

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

To add a session

Click besides the Session tab.

Note: You need to create a new connection for each new SQL Optimizer session.

  

Related Topics

Tutorial: SQL Optimizer

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation