SQL Table Name: STATEMENTS
Contains SQL Statement Index entries that can be accessed by the current user in the current namespace.
READONLY = 1 means that objects can be created, opened but not saved or deleted. Tables are projected to SQL as READONLY.
Value of %defschema when the statement was compiledproperty Error as %String(MAXLEN=4096);
Error string recorded for this planproperty Frozen as %Integer;
0/1/2/3 flag which defines if the statement plan Unfrozen (0), Frozen/Explicit (1), Frozen/Upgrade (2), or Unfrozen/Parallel (3)property FrozenDifferent as %Boolean;
True if the frozen plan is different to what we would use if the plan was not frozenproperty Hash as %String(MAXLEN=32) [ Required ];
Internal unique statement hash used as the ID for the statement.relationship Locations as INFORMATION.SCHEMA.STATEMENTLOCATIONS(XMLPROJECTION="NONE") [ Inverse = Statement,Cardinality = children ]; property NaturalQuery as %Boolean;
Set to true for 'natural' queries which are already maximally efficient and for which we do not collect any statistics as the overhead of statistical collection would have a significant impact on the statement performance.property Packages as %Library.List;
Value of packages argument passed to SQL compiler when the statement was compiledproperty ParentHash as %String(MAXLEN=32) [ Required ];
Hash of this statement's parent statement. Only defined if this is a recursive compile for %PARALLEL statements. This references the root parent's hash.property Plan as list of %Binary(MAXLEN=65536);
Query planrelationship PrivilegeRelations as INFORMATION.SCHEMA.STATEMENTPRIVOBJECTS [ Inverse = Statements,Cardinality = children ]; relationship Relations as INFORMATION.SCHEMA.STATEMENTRELATIONS [ Inverse = Statement,Cardinality = children ]; property SQLSchemaPath as %Library.List;
Value of %sqlSchemaPath when the statement was compiledproperty SqlComp as %String(MAXLEN=32);
SQL Compilation mode, Logical, Odbc, Display, Runtime, etc., when the statement was compiledproperty StatAverage as %Double [ Calculated ];
Average time spent running this queryproperty StatCount as %Integer;
Total number of times we have recorded this query being runproperty StatFirst as %Date;
First day we recorded statistics from running this queryproperty StatStdDev as %Double [ Calculated ];
Standard deviation of the time measurement for this queryproperty StatTotal as %Double;
Total time spent running this queryproperty StatVariance as %Double;
Variance in time from running this queryproperty Statement as %String(COLLATION="SQLSTRING(150)",MAXLEN=262144); property Switch as %String(MAXLEN=32);
Value of %switch when the statement was compiledproperty Timestamp as %TimeStamp;
Timestamp value for when the plan was saved.property Version as %String(MAXLEN=200);
$zversion string for when the plan was saved.