When you create a permanent table in an SAP Sybase IQ database, SAP Sybase IQ automatically stores permanent table columns in default indexes that facilitates a type of query called a projection.
The IQ UNIQUE option (CREATE TABLE or plug-in Column Properties page)
The data type of the column and its width
The IQ PAGE SIZE option (CREATE DATABASE or SAP Control Center Create Databases wizard)