When you create a table and specify its columns, Sybase IQ automatically creates certain default storage structures to optimize query processing. If you know what kinds of queries you plan to run, you can add multiple indexes to any column.
It is faster to create all the indexes needed before you insert data into your database. You can drop any of the optional indexes later if you decide you don't need it.