Table Information
Use this page to view general information about a table that contains times series data.
- Type
- The type of table: standard table or virtual table.
- Row size
- The row size in bytes.
- Dbspace
- The dbspace that contains the table.
- Base table
- For a virtual table, the standard table that the virtual table is based on.
- TimeSeries column
- For a virtual table, the column in the standard table that holds the TimeSeries subtype.
- TimeSeries subtype
- For a virtual table, the name of the TimeSeries subtype on which the table is based.
- Lock level
- Lock mode for the table: page, row, or table.
- Data pages
- For a standard table, the number of data pages that have ever been initialized by the database server.
- First extent
- The size of the first extent in kilobytes.
- Next extent
- The size of the next extent in kilobytes.
- Compression
- An indicator of whether compression is enabled for the table. This information is displayed for Informix® 11.50.xC6 or later.
- Row auditing
- An indicator of whether the table is included in row-level auditing when selective row-level auditing is enabled for the database server. This information is displayed for Informix 11.70.