Use Run Length Encoding (RLE)

For sorted columns with many repeating values, explicitly use run-length encoding (RLE) in your projections. The default (AUTO) encoding may save some space, but it’s slower.

However, RLE is not suitable for big high cardinal columns, such as primary keys. These should use the default encoding.