SQL Optimizer for DB2 ZOS 5.6.2 - Installation Guide

SQL Options

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

To set SQL Options

1. Click .

2. Select Optimize SQL | SQL Rewrite | SQL Options

3. Review the following for additional information:

   Set Current Degree	Specify whether to set the current degree of intra-partition parallelism. Note the following: The value ANY lets the database optimizer choose and appropriate degree depending on the resources. The value 1 prevents the database optimizer from running queries concurrently.
   Set Value for the "Optimize for" Option	Specify the number of rows to optimize. If this option is not selected, then it is assumed that all rows will be retrieved.

Related Topics

Intelligence Options

Quota Options

Optimization Options