For smaller tables that may not have data on all AMPs, use a COLLECT STATISTICS or COLLECT SUMMARY STATISTICS request. Note that the COLLECT STATISTICS estimate is based on sample data from a single AMP.
The SHOW STATISTICS VALUES and COLLECT STATISTICS SUMMARY requests provide BLC data only about manually compressed tables, not tables compressed with temperature-based compression.