Sybase IQ optimizes loading of data for a large or small set of distinct values, based on the setting of the MINIMIZE_STORAGE database option, and parameters you specify when you create your database and tables. Parameters that affect load optimization include:
The UNIQUE and IQ UNIQUE options, and the data type and width of the column, all specified in the CREATE TABLE or ALTER TABLE command.
The IQ PAGE SIZE, specified in the CREATE DATABASE command.
For details of how these parameters affect loading, and information on how to specify them, see “Creating tables” and “Choosing an IQ page size”.
