15.00 - Interval Histogram Limits - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

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