SQL/MX 2.x Reference Manual (H06.04+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-77
Examples of Histogram Tables
•
Use the SELECT statement to retrieve the statistics in the HISTINTS table
generated by the preceding UPDATE STATISTICS statement (the columns are
arranged horizontally):
SELECT * FROM HISTINTS;
TABLE_UID HISTOGRAM_ID INTERVAL_NUMBER
INTERVAL_ROWCOUNT INTERVAL_UEC INTERVAL_BOUNDARY
-------------------- ------------ ------------
-------------------- -------------------- ---------------
211813264440965573 10036622 0
0 0 (1)
211813264440965573 10036622 1
4 4 (32)
211813264440965573 10036622 2
4 4 (72)
211813264440965573 10036622 3
3 3 (89)
211813264440965573 10036622 4
3 3 (109)
211813264440965573 10036622 5
3 3 (180)
211813264440965573 10036622 6
3 3 (203)
211813264440965573 10036622 7
3 3 (207)
211813264440965573 10036622 8
3 3 (210)
211813264440965573 10036622 9
3 3 (213)
211813264440965573 10036622 10
3 3 (216)
211813264440965573 10036622 11
3 3 (219)
211813264440965573 10036622 12
3 3 (222)
211813264440965573 10036622 13
3 3 (225)
211813264440965573 10036622 14
3 3 (228)
211813264440965573 10036622 15
3 3 (231)
211813264440965573 10036622 16
3 3 (234)
211813264440965573 10036622 17
3 3 (337)
211813264440965573 10036622 18
3 3 (568)
211813264440965573 10036622 19
3 3 (992)
211813264440965573 10036622 20
3 3 (995)
--- 21 row(s) selected.