Previous Topic: Determining What Statistics to CollectNext Topic: Statistics About the Encyclopedia Profile


Statistics About Encyclopedia Tables

The SQL queries listed in the following illustrations gather statistics from the encyclopedia tables. Note that you replace encydbas with the name of your encyclopedia database.

Number of Image Copies and Reorganizations:

Number of image copies and reorganizations

Number of Rows on Encyclopedia tables:

Number of rows and encyclopedia tables

Amount of Free Space on Large Tablespaces:

Amount of free space on large tablespaces

Number of Tablespace Partitions or Segmented Tablespaces:

Number of tablespace partitions or segmented tablespaces

More information:

Performance Recommendations