Disadvantages of Compression

·          Does not compress varchar columns.

·   There should not be any spoolspace usage differences, because where compressed values are converted back into spoolspace, there should have been a spool file anyway. The spoolspace usage differences may not be fully understood and tested yet.

Tweet