Type

Description

Use For

RLE

RLE (Run Length Encoding) replaces sequences of the same data values within a column by a single value and a count number.

sorted columns in which the average number of repeated rows exceeds ten.

DELTAVAL

DELTAVAL (Delta Encoding) stores only the differences between sequential data values rather than the values themselves.

columns that store sorted integer or date data that has a narrow range of values.

NONE

automatic encoding (default)

all columns not suitable for RLE or DELTAVAL.