Column Statistics Histogram Table
This table returns one row for each histogram value of each column of each table of each open database on which an UPDATE STATS has been executed.
| Column Name | Description |
|---|---|
| eq_total | Number of
sampled column values matching val. |
| ne_total | Number of
sampled column values between this val and the next val entry. |
| val | Character string representation of the column value. |
| colrid | Rowid of
syscolstats row with which this row is joined. |
The eq_total column contains the count of the number of sampled rows that have the same column value as val. This is used in the computation of the restriction factor for equality conditionals. The ne_total contains the count of the number of sampled rows that have a column value that lies between this entry's val and the next entry's val. This value and the eq_total are used in the computation of the restriction factor for inequality conditionals.