SQL/MX 2.x Query Guide (G06.24+, H06.03+)

Keeping Statistics Current
HP NonStop SQL/MX Query Guide—523728-003
3-9
Testing the Results for SQL/MX Tables
f. If necessary, restore backup histogram tables:
> DELETE FROM HISTOGRAMS;
> INSERT INTO HISTOGRAMS SELECT * FROM myhist where
table_uid in (select object_uid from
CAT.DEFINITION_SCHEMA_VERSION_1200.OBJECTS);
> DELETE FROM HISTOGRAM_INTERVALS;
> INSERT INTO HISTOGRAM_INTERVALS SELECT * FROM myhistint
where table_uid in (select object_uid from
CAT.DEFINITION_SCHEMA_VERSION_1200.OBJECTS);