Wednesday, July 2, 2014

Compress in Netezza

There is no concept of specifying COMPRESS explicitly at column levels inside the table structure in Netezza.

Netezza compression is built in from Netezza 4.5 onwards, achieves typically over 30% savings.