ASA Database Administration Guide
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.
100 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.
SQL Anywhere Studio 9.0.1
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.