Chat now with support
Chat mit Support

SQL Optimizer for DB2 ZOS 5.6 - User Guide

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

XIXSCAN

Welcome > SQL Operations > XIXSCAN

Access and scan an XML index.

This operation returns DOCID and NODWID pairs.

 

Optimize SQL

Optimize SQL > 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.

About Optimizing SQL

Optimize SQL > 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

Optimize SQL > 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

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen