Was this helpful?
DROP STATISTICS Examples
1. Delete the statistics created for all columns in tables a and b and columns x, y, and z in table c:
DROP STATISTICS FOR a, b, c(x, y, z);
2. Delete all column group statistics that involve the columns x, y, z in table c:
DROP STATISTICS FOR c(x, y, z) WITH COLUMN GROUP;
3. Delete all statistics for table a:
DROP STATISTICS FOR a WITH COLUMN COMPARE, COLUMN GROUP
Last modified date: 11/09/2022