Block Level Compression on an existing table

Database
Enthusiast

Block Level Compression on an existing table

Does anyone know if it's possible to block level compress and exisiting table without creating a new table and inserting into? If so, a syntax example would be much appreciated.

Thanks.
2 REPLIES
Teradata Employee

Re: Block Level Compression on an existing table

If the table already contains rows, you need to use the Ferret utility to compress or uncompress it.

If the table is empty, you control the compression behaviour by query banding on the first insert (provided the DBC compression switches have been set accordingly):
set query_band = 'blockcompression=yes;' for session; --(or for transaction)

Regards Michael
Enthusiast

Re: Block Level Compression on an existing table

Great, thank you. Looks like I need to take a look at the ferret utility. Thanks again.