Collecting statistics by using the Data Source Explorer

Use the Data Source Explorer to gather RUNSTATS recommendations directly from subsystems, schemas, or tables.

Before you begin

Procedure

  1. After connecting to the subsystem in the Data Source Explorer, expand the connection to view the subsystem icon.
  2. Generate RUNSTATS recommendations by following one of these steps:
    Option Description
    To generate RUNSTATS recommendations for collecting statistics for all tables that are in the subsystem Right-click the subsystem icon and select Analyze and Tune > Collect Statistics.
    To generate RUNSTATS recommendations for collecting statistics for all tables that are in one or more schemas Expand the subsystem until you find the schema or schemas that you want. Select them, right-click them, and select Analyze and Tune > Collect Statistics.
    To generate RUNSTATS recommendations for collecting statistics for one or more tables Expand the subsystem until you find the table or tables that you want. Select them, right-click them, and select Analyze and Tune > Collect Statistics.

Results

The RUNSTATS recommendations are generated and the Collect Statistics window opens. You can choose to whether to remove RUNSTATS recommendations for any objects and then run the remaining recommendations.

Feedback