Chat now with support
Chat with Support

SQL Optimizer for DB2 ZOS 5.6.1 - User Guide

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

Index Setting Options

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

To set index settings

  1. Click .

  2. Select Optimize SQL | Index Generation | Index Settings.
  3. Review the following for additional information:

    Total number of rows sampled for statistics calculations (%) Enter the percentage of rows to retrieve from a table to sample when calculating the selectivity of data for generating index alternatives.

 

Related Topics

Intelligence Options (Index Generation)

Related Documents