Online Documentation for SQL Manager for DB2

Setting runstats options

This step of the wizard allows you to set the runstats options.

 

 

 

Table options

 

Collect table statistics

When this option is selected, table statistics are collected.

 

Collect column statistics

When this option is selected, column statistics are collected.

 

Specify whether basic column statistics are to be collected on all columns or on key columns only.

 

Collect distribution statistics

If this option is enabled, both basic statistics and distribution statistics are collected on the columns.

 

Specify whether distribution statistics are to be collected on all columns or on key columns only.

 

If necessary, specify the Frequency and the Quantile values that will be used to determine the maximum number of frequency and quantile statistics to be collected for the columns.

 

 

Index options

 

Collect index statistics

When this option is selected, index statistics are collected.

 

Collect detailed statistics

Use this option to calculate extended index statistics.

 

Collect sampled statistics

Use this option to employ a CPU sampling technique when compiling the extended index statistics.

 

Access mode

 

Read-only

This option specifies that other users can have read/write access to the table while statistics are calculated.

Read/Write

This option specifies that other users can have read-only access to the table while statistics are calculated.

 

Sampling options (available for server version 9.7)

 

System

This option allows RUNSTATS to collect statistics on a sample of the data pages from the table(s).

Bernoulli

This option allows RUNSTATS to collect statistics on a sample of the rows from the table or statistical view.

 

 

Click the Next button to proceed to running statistics.