Interval Histogram Limits
|
Parameter |
Value |
|
Number of hash values. |
4.2 x 109 |
|
Maximum number of intervals per index or column set histogram. The system‑wide maximum number of interval histograms is set using the MaxStatsInterval parameter of the DBS Control record or your cost profile. For descriptions of the other parameters listed, see SQL Request and Transaction Processing. |
500 |
|
Default number of intervals per index or column set histogram. |
250 |
|
Maximum number of equal‑height intervals per interval histogram. |
500 |