Index Setting Options

SQL Optimizer for IBM DB2 z/OS

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

Index Options

Intelligence Options (Index Generation)