The following data types are identified as being more efficient within Infobright:

Columns stored as integers are much more efficient (easier to sort, better described by Knowledge Nodes, etc.) than other data types. So if possible, store data as any of the following:

TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT
DECIMAL — note: storing as (10,0) will be much faster than (10,5)
DATE, TIME

Special case data types:

CHAR, VARCHAR — these types are covered in the Knowledge Grid, but where possible should be replaced numeric values, as they are better optimized and faster to decompress

Less optimized data types:

BINARY, VARBINARY
FLOAT
DOUBLE
TINYTEXT, TEXT

DECIMAL is a different, relatively less efficient PHYSICAL representation of INTEGER. DECIMAL is much more efficient than FLOAT or DOUBLE and therefore, should be used in place of FLOAT or DOUBLE if possible.