Top area of the window
The top area of the Table Statistics window shows general information about
the table.
The columns in the window show both those statistics that were gathered at
the time of the explain, and those that currently exist in the system catalog
tables.
Rows in the Table Statistics window
The following information is shown in the rows of the Table Statistics
window:
- CREATE_TIME
- The date and time that the table was created.
- STATS_TIME
- The last time a change was made to any recorded statistics for the
table.
To see a troubleshooting tip, click on Catching inefficient access plans.
- CARD
- The number of rows in the table.
If the cardinality is zero, ensure that you used runstats after
making your table updates.
- NPAGES
- The number of pages of the table that contain one or more rows.
- FPAGES
- The number of file pages used by the table.
- COLCOUNT
- The number of columns in the table.
- OVERFLOW
- The number of overflow pages used by the table.
- TABLESPACE
- The name of the table's primary table space.
- INDEX_TABLESPACE
- The name of the table space that contains all indexes for the
table.
- LONG_TABLESPACE
- The name of the table space that contains all long data (LONG or LOB
column types) for the table.