Indexing

Indexing selection and solutions for SAP Sybase IQ.

• Indexing Tips
  Choose the correct column index type to make your queries run faster.
• When and Where to use Indexes
  Indexes are the primary tuning mechanisms inside SAP Sybase IQ. Knowing when and where to use indexes can make your queries run faster.
• Simple Index Selection Criteria
  Answers to some simple questions can help you choose the right index for a column.
• HG Index Loads
  Relative to other indexes, the HG indexes are more expense to maintain during data loads and deletions. A main contributor to the performance of the HG index is the location of the data within the HG index structure: the sparsity or density of the operation.
• Multi-Column Indexes
  Currently, only HG, UNIQUE HG, UNIQUE CONSTRAINT, and PRIMARY KEY indexes support multiple columns in index creation, but multi-column indexes are also useful for GROUP BY and ORDER BY statements.