The SYSOPTSTAT system view stores the cost model calibration information as computed by the ALTER DATABASE CALIBRATE statement. The contents of this view are for internal use only and are best accessed via the sa_get_dtt system procedure. The underlying system table for this view is ISYSOPTSTAT.
Column name | Column type | Column constraint |
---|---|---|
stat_id | UNSIGNED INT | NOT NULL |
group_id | UNSIGNED INT | NOT NULL |
format_id | SMALLINT | NOT NULL |
data | LONG BINARY |
stat_id For system use only.
group_id For system use only.
format_id For system use only.
data For system use only.
PRIMARY KEY (stat_id, group_id, format_id)