Sybase IQ’s column-based indexing structure optimizes your ability to perform selections or calculations on attributes of interest to you. For the best performance, you need the right set of indexes for your data and queries. Your database should have an index on every column that affects performance. See Chapter 6, “Using Sybase IQ Indexes” for details on choosing the right indexes.
