Neoview SQL Reference Manual (R2.4)

UPDATE STATISTICS FOR TABLE demolition_sites
ON (zip, type);
• This example removes all histograms for table DEMOLITION_SITES:
UPDATE STATISTICS FOR TABLE demolition_sites CLEAR;
• This example selectively removes histograms for column STREET in table ADDRESS:
UPDATE STATISTICS FOR TABLE address ON street CLEAR;
UPDATE STATISTICS Statement 207