User guide

Managing Tables12-34
Figure 12-24. Update Statistics Window.
Choose Update Options
Use the Update Statistics window to update the statistics on a set of tables
as shown in Figure 14-23. The selected tables are shown in the Table Name
field. The Update Statistics field for each table is set to Y (for yes).
If you do not want to update statistics for a table, click on the
corresponding Update Statistics field. The value of the field changes to N
(for no), indicating that the table’s statistics will not be updated.
Before updating the statistics, set the following statistics options. Refer to
Figure 12-24 as needed.
1. Enable or disable the recompile option:
• To enable or disable the option for one table, click on Recompile for
the table. The value of the Recompile field changes to Y if it was N
and vice versa.
• To enable the option for all tables, click on
SetRecompileOptionToYes. The Recompile field changes to Y in all
tables.