Restoring statistics for tables and indexes

You can restore previously saved original statistical sets from a table or an index.

Procedure

  1. Select option 2, Advanced Db2® SQL PA Processing, from the Figure 1.
    The Advanced Processing Options panel is displayed.
  2. Select option 1 to display the Modify Statistics panel, as shown in Figure 2.
  3. To restore saved statistics for an index or table, select option 3.