To revert fixed missing statistics, use the undo_fix_stats action. undo_fix_stats deletes the statistics that are specified in an XML file whose missing counts are equal to, or exceed, the number specified by the -m option.
For example:
QPTune -A undo_fix_stats -m 1 -i missingstats.xml -v -S my_host:4816/my_database
Executing : QPTune -U sa -P [unshown] -S jdbc:sybase:Tds:my_host:4816/my_database -A undo_fix_stats -M allrows_dss -T 0 -i missingstats.xml -o metrics.xml -f null -c config.xml -l 5 -e elap_avg -d 5,5 -m 1 -n null -v You are now connected to database: my_database Fix statistics on "Fri Sep 26 10:20:23 PDT 2008" ----------------------------------------------------------- Details of statements(s) fixed: ------------------------------- Fixed statistics:[Delete] Y(y4,y2) [INFO] Fix Statement = delete statistics Y(y4,y2) Fixed statistics:[Delete] Y(y3) [INFO] Fix Statement = delete statistics Y(y3) Fixed statistics:[Delete] Y(y2,y1) [INFO] Fix Statement = delete statistics Y(y2,y1) Fixed statistics:[Delete] Y(y1) [INFO] Fix Statement = delete statistics Y(y1) ----- QPTune finished executing. ------
