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 Updat-ableUpdatable 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.Total number of files for a Hadoop or HBase table; -1 if statistics are not collected, or if the table is neither a Hadoop table nor an HBase 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.Total number of partitions for a partitioned Hadoop table; -1 for a nonpartitioned table.
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. The size of a Hadoop or HBase table in kilobytes; -1 if statistics are not collected, or if the table is neither a Hadoop table nor an HBase table.
NPARTITIONS BIGINT     Reserved for future use.Total number of partitions for a Hadoop table; -1 if statistics not collected, or if not a Hadoop table.
NFILES BIGINT     Reserved for future use.Total number of files for a Hadoop or HBase table; -1 if statistics not collected, or if not a Hadoop or HBase table.
TABLESIZE BIGINT     Reserved for future use.The size of a Hadoop or HBase table in kilobytes; -1 if statistics not collected, or if not a Hadoop or HBase table.
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   N 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.