Confused on which SAP Sybase IQ index to use and why?

SAP Sybase IQ Indexes and Indexing Techniques

by Mark Mumy

Are you new to SAP Sybase IQ? Have you used the product but are still not clear on what indexes to use or when to use them? Have you just migrated to SAP Sybase IQ 16 and are wondering if there are any indexing changes? This blog will discuss indexes and strategies for SAP Sybase IQ.

Basic Indexes
When creating a table in IQ, a default index is placed on every column. This index is referred to as a Fast Projection (FP) index. In order to enable optimized FP indexes, one must set the Minimize_Storage option to ON.
set option public.minimize_storage=’on’;

Read the entire post on Mark Mumy’s blog

Share Button

Leave a Reply

Your email address will not be published. Required fields are marked *