Contents Index MIN_PASSWORD_LENGTH option [database] NEAREST_CENTURY option [compatibility]

ASA Database Administration Guide
  Database Options
    Alphabetical list of options

MIN_TABLE_SIZE_FOR_HISTOGRAM option [database]


Function 

Specify the minimum table size for which histograms are created.

Allowed values 

Integer, greater than or equal to zero.

Scope 

Can be set for the PUBLIC group only.

Default 

1 000 rows

See also 

Optimizer estimates

Description 

The optimizer uses histograms to estimate the selectivity of search conditions. For small tables, a histogram does not significantly improve the optimizer's ability to choose an efficient plan. This option lets you specify the minimum number of rows a table must have in order for the optimizer to create a histogram for columns in the table.

You can change the setting to build histograms for smaller tables, or to build them only for very large tables. This option is ignored by the CREATE STATISTICS statement: when a CREATE STATISTICS statement is executed, a histogram is created regardless of the number of rows in the table.


Contents Index MIN_PASSWORD_LENGTH option [database] NEAREST_CENTURY option [compatibility]