Skip to main content

INFORMATION.SCHEMA.STATEMENTPARAMETERSTATS

Class INFORMATION.SCHEMA.STATEMENTPARAMETERSTATS Extends (%Persistent, %XML.Adaptor) [ Final, Owner = {_PUBLIC}, SqlRowIdPrivate, SqlTableName = STATEMENT_PARAMETER_STATS, StorageStrategy = SQLStorage, System = 4 ]

Daily parameter statistics of this SQL statement

Parameters​

READONLY​

Parameter READONLY = 1;

Properties​

Values​

Property Values As %List [ Required, SqlColumnNumber = 2 ];

List of actual parameter values used in order

ValuesHash​

Property ValuesHash As %String [ Private, Required, SqlColumnNumber = 3 ];

Internal hash for this list of parameter values

Frequency​

Property Frequency As %Integer [ Required, SqlColumnNumber = 4 ];

Number of times this list of parameter values was used

TotalRuntime​

Property TotalRuntime As %Double(SCALE = 3) [ Private, Required, SqlColumnNumber = 5 ];

Total runtime with this list of parameter values

AverageRuntime​

Property AverageRuntime As %Double(SCALE = 3) [ Calculated, Required, SqlColumnNumber = 6, SqlComputeCode = { set {*}={TotalRuntime}/{Frequency} }, SqlComputed ];

Average runtime with this list of parameter values

Day​

Relationship Day As INFORMATION.SCHEMA.STATEMENTDAILYSTATS [ Cardinality = parent, Inverse = Parameters ];