SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

MXCI Commands
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
4-114
Examples of SHOWSTATS
Hist ID # Ints Rowcount UEC Colname(s)
========== ====== =========== ==== ==========
1013503854 5 5 5 SYSKEY
1013503849 5 5 5 ID
1013503844 5 5 5 NAME
1013503839 4 5 4 SUBJECT
--- SQL operation complete.
•
This example displays the detailed histogram for the column, dob:
>>SHOWSTATS FOR TABLE student ON dob DETAIL;
Detailed Histogram data for Table SHOWSTATS.SCH.STUDENT
Table ID: 520295568744812
Hist ID: 1126276622
Column(s): DOB
Total Rows: 6
Total UEC: 6
Low Value: (DATE '1976-05-15')
High Value: (DATE '1999-09-13')
Intervals: 6
Number Rowcount UEC Boundary
====== ========= ==== ==================
0 0 0 (DATE '1976-05-15')
1 1 1 (DATE '1976-05-15')
2 1 1 (DATE '1981-01-22')
3 1 1 (DATE '1985-12-12')
4 1 1 (DATE '1987-10-19')
5 1 1 (DATE '1991-11-25')
6 1 1 (DATE '1999-09-13')
--- SQL operation complete.