Optimizing Storage and Query Performance

When you create a permanent table in an IQ database, Sybase IQ automatically stores it in a default index that facilitates a type of query called a projection.

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 MINIMIZE_STORAGE option (SET OPTION or plug-in Database Options dialog)
The data type of the column and its width
The IQ PAGE SIZE option (CREATE DATABASE or plug-in Create Database wizard)

Effect of IQ UNIQUE
See the following table for implications of the CREATE TABLE option IQ UNIQUE.

Parent topic: Guidelines for Creating Tables