Compression loves patterns.

The more repetitive the data is, the better the compression ratio becomes.

Examples:

• status columns

• product categories

• log data

• repeated text

• time-series data

Techniques like:

• Dictionary Encoding

• Run-Length Encoding (RLE)

can reduce storage dramatically when values repeat often.

wanna learn more? check out this post for more detials.