Sample output for histograms

Histogram for column:               "city"
Column datatype:                    varchar(20)
Requested step count:               20
Actual step count:                  20

optdiag first prints summary data about the histogram, as shown in Table 6-8.

**Table 6-8: Histogram summary statistics**
Row label	Information provided
Histogram for column	Name of the column.
Column datatype	Datatype of the column, including the length, precision and scale, if appropriate for the datatype.
Requested step count	Number of steps requested for the column.
Actual step count	Number of steps generated for the column. This number can be less than the requested number of steps if the number of distinct values in the column is smaller than the requested number of steps.

Histogram output is printed in columns, as described in Table 6-9.

**Table 6-9: Columns in optdiag histogram output**
Column	Information provided
Step	Number of the step.
Weight	Weight of the step.
(Operator)	<, <=, or =, indicating the limit of the value. Operators differ, depending on whether the cell represents a range cell or a frequency call.
Value	Upper boundary of the values represented by a range cell or the value represented by a frequency count.

No heading is printed for the Operator column.