Question & Answer
Question
Do the new compression algorithms in Netezza 6.0 require me to recreate all of my tables?
Answer
In Netezza Release 6.0, a new set of compression algorithms is available. This set of algorithms is known as CTA2 (Compiled Table Algorithms version 2).
Once enabled, any new block of data written to a table will be compiled using these new algorithms. Any existing compressed data (using the old CTA1 algorithms) can still be read from the disk without any issues. You do not need to recreate existing tables.
However, IBM recommends that you use the GROOM TABLE command to re-compress all of the data in your tables because the updated algorithms include support for character data as well as improved handling of numeric data. In addition to re-compiling a table, the groom operation also replaces the need to reclaim and it also re-organizes the contents according to the 'ORGANIZE BY' clause for the table.
Historical Number
NZ182953
Was this topic helpful?
Document Information
Modified date:
17 October 2019
UID
swg21568394