Advantages of Compression

The below are the advantages of data compression in Teradata.

·      Compression results in shorter rows which are generally more performant.

·      Column compression provides the following capacity and performance benefits:

              Reduced capacity

            Reduced I/O traffic

            Moderate CPU savings

·    The I/O savings correlates to the percentage of data compressed out of a row.

·    Table backups use the compressed format, so backups will also be faster.

Tweet