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)