ASA Database Administration Guide
Database Options
Alphabetical list of options
Specify the minimum table size for which histograms are created.
Integer, greater than or equal to zero.
Can be set for the PUBLIC group only.
1 000 rows
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.