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 anluc_mainctrlpan.html#anluc_mainctrlpan__f1xfig55.
    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.