Hot tables and Indexes

Key Features of Hot tables and Indexes

1) Default and Customized Modes:

There are two modes available to control which performance metrics are displayed.

1. Default Mode: By default, the table displays 12 core columns considered the most critical for assessing table activity. These pre-selected columns include dbsname, tabname, partnum, lockreqs, lockwts, deadlks, lktouts, bufreads, bufwrites, seqscans, pagreads, and pagwrites.
2. Customized Mode: The customized mode provides users with complete independence to select any combination of the 16 available performance metrics columns.
   1. Enabling Customization: Click the Customise Table button.
   2. Selection Wizard: A wizard opens listing all 16 columns from sysptprof with their descriptions. The 12 default columns are pre-selected.
   3. Column Selection: Users can select or deselect any column. A Select All checkbox allows for quick viewing of all available metrics.
   4. Reset to Default: To switch back to the original 12-column default view, click the Reset to Default button. A confirmation prompt will appear asking "Are you sure you want to reset columns to default view?"

2) Database Selection:

A dropdown menu lists all the databases in the Informix server instance, including user-defined and system databases. Users can select a specific database to view only tables within that scope, or select All to see tables across the entire instance.

3) Include System Catalog:

A checkbox filter is available to control the visibility of system catalog tables. Checking this displays all tables. Unchecking this excludes most internal system catalog tables (those with tabid <= 99), except for a specific few often monitoned for system maintenance (sysblderrorlog, sysbldobjects, etc.).

4) Search:

Users can search and filter the table by typing keywords matching with the 16 columns of sysptprof table.