SQL Language Guide : 8. SQL Statements : DROP STATISTICS : DROP STATISTICS Examples
 
Share this page                  
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