SYSOPTSTAT system view

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 Data type Description
stat_id UNSIGNED INT For system use only.
group_id UNSIGNED INT For system use only.
format_id SMALLINT For system use only.
data LONG BINARY For system use only.

Constraints on underlying system table

PRIMARY KEY (stat_id, group_id, format_id)