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

MXCI Commands

HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001

4-111

Examples of SHOWSTATS



This example displays the histogram for every column in the table for which

statistics are available:

>>SHOWSTATS FOR TABLE student ON EVERY COLUMN;

Histogram data for Table SHOWSTATS.SCH.STUDENT

Table ID: 520295568744812

Hist ID # Ints Rowcount UEC Colname(s)

======= ==== ======== ==== ==========

1126276632 6 6 6 ROLLNO

1126276627 6 6 6 NAME

1126276622 6 6 6 DOB

1126276617 6 6 6 SUBJECT

--- SQL operation complete.



This example displays the histogram for the column, name:

>>SHOWSTATS FOR TABLE student ON name;

Histogram data for Table SHOWSTATS.SCH.STUDENT

Table ID: 520295568744812

Hist ID # Ints Rowcount UEC Colname(s)

======== ===== ========= ===== ==========

1126276627 6 6 6 NAME

--- SQL operation complete.



This example displays the histogram for the SQL/MP table, mpteach:

>>SHOWSTATS FOR TABLE \DMR15.$DATA07.CHANVOLM.mpteach ON

EVERY COLUMN;

Histogram data for Table \DMR15.$DATA07.CHANVOLM.MPTEACH

Table ID: 212193205206643373