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.