Optimizing Storage and Query Performance

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.

SAP Sybase IQ optimizes this structure for query performance and storage requirements, based on these factors:

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 Sybase Control Center Create Databases wizard)

Effect of IQ UNIQUE
IQ UNIQUE is an optional column constraint that explicitly defines the cardinality of a column and determines whether the column loads as Flat FP or NBIT.

Parent topic: Guidelines for Creating Tables