%SQL.Util.TuneTableStats

class %SQL.Util.TuneTableStats extends %XML.Adaptor, %Library.RegisteredObject

Property Inventory

class
duration
endtime
extentsize
fields
maps
samplepercent
schema
storageinfo
table
type
username

Properties

property class as %String (MAXLEN = 127);

Name of the class

Property methods: classDisplayToLogical(), classGet(), classIsValid(), classLogicalToDisplay(), classLogicalToOdbc(), classNormalize(), classSet()

property duration as %Numeric (SCALE = 6);

For collected table statistics: duration of collecting table stats for this table in sec up to microsec

Property methods: durationDisplayToLogical(), durationGet(), durationIsValid(), durationLogicalToDisplay(), durationNormalize(), durationSet(), durationXSDToLogical()

property endtime as %PosixTime;

For collected table statistics: end time (time to save this information)

Property methods: endtimeCurrentTimeStamp(), endtimeCurrentUTCTimeStamp(), endtimeDateToLogical(), endtimeDisplayToLogical(), endtimeGet(), endtimeIsValid(), endtimeLogicalToDate(), endtimeLogicalToDisplay(), endtimeLogicalToOdbc(), endtimeLogicalToTime(), endtimeLogicalToTimeStamp(), endtimeLogicalToUnixTime(), endtimeLogicalToXSD(), endtimeNormalize(), endtimeOdbcToLogical(), endtimeSet(), endtimeTimeStampToLogical(), endtimeTimeToLogical(), endtimeUnixTimeToLogical(), endtimeXSDToLogical()

property extentsize as %Library.BigInt;

EXTENTSIZE base table

Property methods: extentsizeDisplayToLogical(), extentsizeGet(), extentsizeIsValid(), extentsizeLogicalToDisplay(), extentsizeNormalize(), extentsizeSet(), extentsizeXSDToLogical()

relationship fields as array of %SQL.Util.TuneTableStatsFields [ InitialExpression = $listbuild("%SQL.Util.TuneTableStatsFields","table",+$this,"children",0,0) , Transient , Inverse = table , Cardinality = children ];

Property methods: fieldsGet(), fieldsGetObject(), fieldsGetObjectId(), fieldsGetSwizzled(), fieldsIsEmpty(), fieldsIsValid(), fieldsNewObject(), fieldsRClose(), fieldsRExec(), fieldsRFetch(), fieldsRelate(), fieldsSQLCompute(), fieldsSet(), fieldsUnRelate()

relationship maps as array of %SQL.Util.TuneTableStatsMaps [ InitialExpression = $listbuild("%SQL.Util.TuneTableStatsMaps","table",+$this,"children",0,0) , Transient , Inverse = table , Cardinality = children ];

Property methods: mapsGet(), mapsGetObject(), mapsGetObjectId(), mapsGetSwizzled(), mapsIsEmpty(), mapsIsValid(), mapsNewObject(), mapsRClose(), mapsRExec(), mapsRFetch(), mapsRelate(), mapsSQLCompute(), mapsSet(), mapsUnRelate()

property samplepercent as %Numeric (MAXVAL = 1, MINVAL = 0, SCALE = 6);

For collected table statistics: the percent of data sampled during table stats collection

Property methods: samplepercentDisplayToLogical(), samplepercentGet(), samplepercentIsValid(), samplepercentLogicalToDisplay(), samplepercentNormalize(), samplepercentSet(), samplepercentXSDToLogical()

property schema as %String (MAXLEN = 127);

Name of the schema

Property methods: schemaDisplayToLogical(), schemaGet(), schemaIsValid(), schemaLogicalToDisplay(), schemaLogicalToOdbc(), schemaNormalize(), schemaSet()

relationship storageinfo as array of %SQL.Util.TuneTableStatsStorageInfo [ InitialExpression = $listbuild("%SQL.Util.TuneTableStatsStorageInfo","table",+$this,"children",0,0) , Transient , Inverse = table , Cardinality = children ];

Property methods: storageinfoGet(), storageinfoGetObject(), storageinfoGetObjectId(), storageinfoGetSwizzled(), storageinfoIsEmpty(), storageinfoIsValid(), storageinfoNewObject(), storageinfoRClose(), storageinfoRExec(), storageinfoRFetch(), storageinfoRelate(), storageinfoSQLCompute(), storageinfoSet(), storageinfoUnRelate()

property table as %String (MAXLEN = 127);

Name of the base table

Property methods: tableDisplayToLogical(), tableGet(), tableIsValid(), tableLogicalToDisplay(), tableLogicalToOdbc(), tableNormalize(), tableSet()

property type as %String (MAXLEN = 127);

Type of the table stats

Property methods: typeDisplayToLogical(), typeGet(), typeIsValid(), typeLogicalToDisplay(), typeLogicalToOdbc(), typeNormalize(), typeSet()

property username as %Library.Username;

For collected table statistics: who collect table stats for this table

Property methods: usernameDisplayToLogical(), usernameGet(), usernameIsValid(), usernameLogicalToDisplay(), usernameLogicalToOdbc(), usernameNormalize(), usernameSet()

%SQL.Util.TuneTableStats

Property Inventory

Properties

Inherited Members

Inherited Methods