SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

MXCI Commands
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
4-113
Examples of SHOWSTATS

This example displays the detailed histogram for the multi-column-group (name,
dob):
>>SHOWSTATS FOR TABLE student ON (name,dob) DETAIL;
Detailed Histogram data for Table SHOWSTATS.SCH.STUDENT
Table ID: 1952836866910076444
Hist ID: 850886066
Column(s): NAME, DOB
Total Rows: 6
Total UEC: 6
Low Value: ('Ajay',DATE '1976-05-15')
High Value: ('vijay',DATE '1999-09-13')
Intervals: 1
Number Rowcount UEC Boundary
====== =========== =========== ========================
0 0 0 ('Ajay',DATE '1976-05-15')
1 6 6 ('vijay',DATE '1999-09-13')
--- SQL operation complete.

This example displays the SHOWSTATS output when a column does not exist:
>>SHOWSTATS FOR TABLE student ON nonexistencecolumn;
*** ERROR[9209] Column NONEXISTENCECOLUMN does not exist in
object SHOWSTATS.SCH.STUDENT.
--- SQL operation failed with errors.