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-116
Examples of SHOWSTATS
•
This example displays the SHOWSTATS output when there are no histograms for
the requested columns:
>>SHOWSTATS FOR TABLE student ON name;
Histogram data for Table SHOWSTATS.SCH.STUDENT
Table ID: 520295568744812
Hist ID # Ints Rowcount UEC Colname(s)
======== ===== ========= ===== ===========
No Histograms exist for the requested columns or groups
--- SQL operation complete.
•
This example displays the SHOWSTATS output if there are no histograms for
some of the requested columns (histogram for the column name is not available):
>>SHOWSTATS FOR TABLE student ON name,subject;
*** WARNING[9225] No histogram data is available for columns
(NAME).
Histogram data for Table SHOWSTATS.SCH.STUDENT
Table ID: 520295568744812
Hist ID # Ints Rowcount UEC Colname(s)
========= ====== ========= ===== ==========
1126276641 6 6 6 SUBJECT
--- SQL operation complete.