Statistics, Including Estimated Compression Ratio
To calculate statistics including the average block size and estimated compression ratio for tables compressed manually with BLC, issue a COLLECT STATISTICS or COLLECT STATISTICS SUMMARY request. For example, this request collects summary statistics on the employee table:
COLLECT SUMMARY STATISTICS ON employee;
For details, see SQL Data Definition Language Syntax and Examples.