Size all data types as accurately as possible, especially character-based data types.
To decide which data type to use for a column, consider these factors:
- SAP Sybase IQ includes a large number od data types.
Using the correct data types for your application leads to optimal performance
gains.
- If HOUR, MINUTE and SECOND information is not necessary, use
DATE instead of DATETIME
- If the data will fit within a TINYINT or
SMALLINT datatype use that rather than
INTEGER or BIGINT
- Do not over allocate storage when defining
NUMERIC() or DECIMAL() as it can
be costly for data that does not need all that level of precision
- CHAR() and VARCHAR() types are fixed width in the
default Flat FP index. The only difference is the addition of 1 byte to
each VARCHAR() row that represents the number of bytes in use.
SAP Sybase IQ includes compression algorithms that
compress large repeating patterns often seen in BINARY(),
CHAR(), VARCHAR(), and
VARBINARY() data types.