8.7. Metadata Procedures

SYSADMIN.setTableStats

Set statistics for the given table.

SYSADMIN.setTableStats(TableName in string, Cardinality in integer)

SYSADMIN.setTableStats(TableName in string, Cardinality in integer)

Copy to Clipboard

Toggle word wrap

SYSADMIN.setColumnStats

Set statistics for the given column.

SYSADMIN.setColumnStats(TableName in string, ColumnName in string, DistinctCount in integer, NullCount in integer, Max in string, Min in string)

SYSADMIN.setColumnStats(TableName in string, ColumnName in string, DistinctCount in integer, NullCount in integer, Max in string, Min in string)

Copy to Clipboard

Toggle word wrap

All stat values are nullable. Passing a null stat value will leave corresponding metadata value unchanged.

SYSADMIN.setProperty

Set an extension metadata property for the given record. Extension metadata is typically used by translators.

SYSADMIN.setProperty(OldValue return clob, Uid in string, Name in string, Value in clob)

SYSADMIN.setProperty(OldValue return clob, Uid in string, Name in string, Value in clob)

Copy to Clipboard

Toggle word wrap

Setting a value to null will remove the property.

The use of this procedure will not trigger replanning of associated prepared plans.