Sybase IQ indexes offer the following benefits over traditional indexing techniques:
Index sizes usually remain small. The entire database can be fully indexed and made available for ad hoc queries in the same space that would be needed to store the raw data. Traditional databases often need three or more times more space.
Queries are resolved by efficiently combining and manipulating indexes on only the relevant columns. This avoids time-consuming table scans.
I/O is minimized, eliminating potential bottlenecks.
Because indexes are compact, more data can be kept in memory for subsequent queries, thereby speeding throughput on iterative analysis.
Tuning is data dependent, allowing data to be optimized once for any number of ad hoc queries.
