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

SQL Optimizer for DB2 ZOS 5.6 - 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)

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation