1. A database system comprising: a processing module; and a storage device communicatively coupled with the processing module and allocated thereto that stores a base table allocated to the processing module, wherein the processing module receives a database query from a client computer system, generates a spool based upon a number of columns of a table, and partitions at least one column of the spool based upon the database query received from the client computer system; and wherein the processing module estimates saving of compression based upon statistics associated with the table, and compresses certain columns when the estimated saving of compression is greater than a predetermined value.