6.1.6 Information output in the cost information view
Among the base tables referenced in the SQL statement, information (table cost information) about the base tables for which cost information has been obtained is output.
The following is an example of the information displayed in the cost information view.
Output example
<<COST Info>>
TABLE : ADBUSER01.T1
COLLECT VERSION : 05-03
COLLECT TIME : 2020-05-25 13:36:46
- Explanation:
-
-
TABLE
The table names of the base tables referenced in the SQL statement for which cost information has been obtained are output.
-
COLLECT VERSION
The version of the HADB server when the cost information for the base tables displayed in TABLE was obtained is output.
-
COLLECT TIME
The date and time when the cost information of the base table displayed in the TABLE was obtained is output.
-
- Note
-
-
The above information is output in order of table names.
-
If the same table is referenced in multiple places in the SQL statement, the information is output with deduplication.
-