Load Performance During Database Definition

The way you define your database, tables, and indexes can have a dramatic impact on load performance.

• Number of Distinct Values
  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
• Index Creation
  To make the best use of system resources, create all of the indexes you need before loading data. While you can always add new indexes later, it is much faster to load all indexes at once.
• Memory Adjustments
  On some platforms you can set command-line options to adjust the amount of memory available.