SYSSTAT.TABLES catalog view

Each row represents a table, view, alias, or nickname. Each table or view hierarchy has one additional row representing the hierarchy table or hierarchy view that implements the hierarchy. Catalog tables and views are included.

Table 1. SYSSTAT.TABLES Catalog View
Column Name Data Type Nullable Updatable Description
TABSCHEMA VARCHAR (128)     Schema name of the object.
TABNAME VARCHAR (128)     Unqualified name of the object.
CARD BIGINT   Y Total number of rows in the table; -1 if statistics are not collected.
NPAGES BIGINT   Y Total number of pages on which the rows of the table exist; -1 for a view or alias, or if statistics are not collected; -2 for a subtable or hierarchy table.
MPAGES BIGINT   Y Total number of pages for table metadata. Non-zero only for a table that is organized by column; -1 for a view, an alias, or if statistics are not collected; -2 for subtables or hierarchy tables.
FPAGES BIGINT   Y Total number of pages; -1 for a view or alias, or if statistics are not collected; -2 for a subtable or hierarchy table.
NPARTITIONS BIGINT     Reserved for future use.
NFILES BIGINT     Reserved for future use.
TABLESIZE BIGINT     Reserved for future use.
OVERFLOW BIGINT   Y Total number of overflow records in the table; -1 for a view or alias, or if statistics are not collected; -2 for a subtable or hierarchy table.
CLUSTERED CHAR (1) Y  
  • T = Table is clustered by insert time
  • Y = Table is clustered by dimensions (even if only by one dimension)
  • Null value = Table is not clustered by dimensions or insert time
ACTIVE_BLOCKS BIGINT   Y Total number of active blocks in the table, or -1. Applies to multidimensional clustering (MDC) tables or insert time clustering (ITC) tables only.
AVGCOMPRESSEDROWSIZE SMALLINT   Y Average length (in bytes) of compressed rows in this table; -1 if statistics are not collected.
AVGROWCOMPRESSIONRATIO REAL   Y For compressed rows in the table, this is the average compression ratio by row; that is, the average uncompressed row length divided by the average compressed row length; -1 if statistics are not collected.
AVGROWSIZE SMALLINT     Average length (in bytes) of both compressed and uncompressed rows in this table; -1 if statistics are not collected.
PCTROWSCOMPRESSED REAL   Y Compressed rows as a percentage of the total number of rows in the table; -1 if statistics are not collected.
PCTPAGESSAVED SMALLINT   Y Approximate percentage of pages saved in a row-organized table as a result of row compression. For a column-organized table, the estimate is based on the number of data pages needed to store the table in uncompressed row organization.-1 if statistics are not collected.
PCTEXTENDEDROWS REAL     Extended rows as a percentage of the total number of rows in the table; -1 if statistics are not collected.