Autocompression and Spools
A spool generated from a table with autocompression does not have any autocompression, though it might have inherited user‑specified compression based on the rules for spool inheriting the compression characteristics of its parent. This means a very large spool relative to the size of the column partitions can be generated if those column partitions are highly compressed by the autocompression and there is little or no selectivity.