Creating Column Indexes

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.

Warning! Be sure to verify that the index is not important before you drop it. Different queries use different indexes, even when they appear to be similar. Dropping the wrong indexes may adversely affect performance. Capture queries, run times, and query plans to determine which indexes are required.

Column Index Types
Each type of column index is designed to speed processing of a certain kind of data.
Adding a Low Fast Index To a Column
In this example, appropriate index types and storage locations have been determined for you. Simply follow the steps to index columns in your table.

Parent topic: Indexing and Loading Data