C.2 Content of STATUS_TABLES

STATUS_TABLES stores cost information related to base tables. Each row stores information for one base table.

The following table describes the contents of STATUS_TABLES.

Table C‒3: Content of STATUS_TABLES
No.	Column name	Data type	Stored information
1	`TABLE_SCHEMA`	`VARCHAR(100)`	Schema name
2	`TABLE_NAME`	`VARCHAR(100)`	Table identifier
3	`COLLECT_TIME`	`TIMESTAMP`	Date and time cost information was collected
4	`N_ROW`	`INTEGER`	Number of rows in the processing-target table If the value in the `IS_N_ROW_COMPLETE` column is `'N'`, the number of rows for which analysis was completed at the time when collection of cost information was canceled is stored.
5	`COLLECT_VR`	`CHAR(8)`	Version of the HADB server that collected cost information^#
6	`IS_COMPLETE`	`CHAR(1)`	Whether collection of the characteristics of the data stored in the processing-target table has been completed^# `'Y'`: Completed `'N'`: Not completed Collection of cost information was canceled because the time required to collect cost information exceeded the maximum (time specified for the `adb_getcst_collect_time` cost information collection option).
7	`IS_N_ROW_COMPLETE`	`CHAR(1)`	Whether acquisition of the number of rows in the processing-target table has been completed^# `'Y'`: Completed `'N'`: Not completed Collection of cost information was canceled because the time required to collect cost information exceeded the maximum (time specified for the `adb_getcst_collect_time` cost information collection option).

#

For a table that satisfies all of the following conditions, a null value is stored in this column of STATUS_TABLES:

Table from which cost information was collected by an HADB server whose version is earlier than 04-03
Table from which cost information was not collected by an HADB server whose version is 04-03 or later