Contains the table’s compression history. Enable the enable monitoring and per object statistics active configuration parameters for this monitoring table to collect data.
The columns for monTableCompression are:
Name |
Datatype |
Attributes |
Description |
---|---|---|---|
InstanceID |
tinyint |
(Cluster Edition only) Server instance ID |
|
DBID |
int |
ID of the database to which this table was transferred |
|
ObjectID |
int |
ID of the compressed object |
|
PartitionID |
int |
ID of the compressed partition |
|
CompRowInserted |
bigint |
Counter |
Number of compressed rows inserted |
CompRowUpdated |
bigint |
Counter |
Number of updated compressed rows |
CompRowForward |
bigint |
Counter |
Number of compressed rows forwarded from the update |
CompRowScan |
bigint |
Counter |
Number of compressed rows accessed |
RowDecompressed |
bigint |
Counter |
Number of rows decompressed |
RowPageDecompressed |
bigint |
Counter |
Number of page-compressed rows decompressed to be row-compressed |
ColDecompressed |
bigint |
Counter |
Number of columns decompressed |
RowCompNoneed |
int |
Counter |
Number of rows not compressed because their compressed row length exceeded their normal row length |
PageCompNoneed |
bigint |
Counter |
Number of pages that are not suitable for page-level compression because Adaptive Server cannot generate a dictionary or index |
PagesCompressed |
bigint |
Counter |
Number of pages compressed at the page-level |
AvgBytesSavedPageLevel |
bigint |
Counter |
Number of bytes page level compression saved |
TableName |
varchar |
NULL |
Name of the compressed table |