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.