Show Table of Contents
8.9. Metadata Procedures
- SYSADMIN.setTableStats
- Set statistics for the given table.
SYSADMIN.setTableStats(TableName in string, Cardinality in integer)
- 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)
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)
Setting a value to null will remove the property.The use of this procedure will not trigger replanning of associated prepared plans.
Where did the comment section go?
Red Hat's documentation publication system recently went through an upgrade to enable speedier, more mobile-friendly content. We decided to re-evaluate our commenting platform to ensure that it meets your expectations and serves as an optimal feedback mechanism. During this redesign, we invite your input on providing feedback on Red Hat documentation via the discussion platform.