Performance is a vital consideration when designing and creating your database. Sybase IQ indexes dramatically improve the performance of database searches over searches in traditional relational databases. Even within Sybase IQ, however, it is important to choose the right indexes for your data, to achieve the greatest performance, and to make best use of memory, disk, and CPU cycles.