Contains the table’s compression history. Enable the enable monitoring, capture compression statistics, 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 the SAP ASE 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 |