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:
- 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.
Sybase IQ includes new compression algorithms that compress large repeating patterns often seen in
BINARY(), CHAR(), VARCHAR(), and VARBINARY() data types.