This is to hold usage statistics on various objects within the meta data
use_stats_s (PK, M: CHAR VARYING(19))
Surrogate key of the table.
object_s (M: CHAR VARYING(19))
use_stats.object_s
The instance handle of the object these statistic describe.
object_t (FNK, M: CHAR(3))
use_stats.object_t
This is the type of object that these statistics apply to.
Defines a foreign key to table ref_object.
ave_create (O: INTEGER)
use_stats.ave_create
This is the arithmetic mean of the number of rows created during the period considered , using a user defined period as the denominator.
ave_delete (O: INTEGER)
use_stats.ave_delete
This is the average number of rows deleted over the period considered using a user defined time period as the denominator (e.g 1200 per day)
ave_rows (O: INTEGER)
use_stats.ave_rows
The arithmetic mean of the number of rows over the period considered.
ave_update (O: INTEGER)
use_stats.ave_update
This is the average (arithmetic mean) of the number of updates over the period considered, using a user defined period of time for the denominator.
end_time (O: DATE)
use_stats.end_time
The end of the period over which these statistic apply.
max_create (O: INTEGER)
use_stats.max_create
This is the number of rows created over the period of time considered.
max_delete (O: INTEGER)
use_stats.max_delete
This is the maximum number of rows deleted during a time period specified by the DBA for the period of time considered.
max_rows (O: INTEGER)
use_stats.max_rows
This is the maximum number of rows over the period of time considered.
max_update (O: INTEGER)
use_stats.max_update
This is the maximum number of updates that took place during the user defined time period during the period considered (e.g 10000 per day)
min_rows (O: INTEGER)
use_stats.min_rows
The minimum number of rows over the period considered.
start_time (O: DATE)
use_stats.start_time
The beginning of the period over which these statistic apply.
prod_versn_s (FSK, O: CHAR VARYING(19))
use_stats.prod_versn
The projection run that produced the objects these statistics apply to.
Defines a foreign key to table prod_versn.
source_s (FSK, O: CHAR VARYING(19))
use_stats.source
The source of the objects these statistics apply to.
Defines a foreign key to table source.