16. Using the Query Optimizer : Specialized Statistics Processing : Display Optimizer Statistics : Delete Optimizer Statistics
 
Share this page                  
Delete Optimizer Statistics
To delete statistics use any of these methods:
Use the -zdl flag with the statdump command. Use the -r and -a flags to specify the tables and columns for which to delete statistics.
This command deletes statistics from the demodb database: columns empno and sex from the emp table and the empno column from the task table:
statdump -zdl demodb -remp -aempno -asex -rtask -aempno
DROP STATISTICS statement
In Director, use the Display Statistics dialog, Options page.
In VDBA, enable the Delete Statistics from Syscat check box. Using this check box with the Specify Tables and Specify Columns check boxes, you can specify the tables and columns for which to delete statistics.