Introduction to Indexes

All IQ database columns with data need an index.

When you create a database in an IQ store, a default index is created automatically on every column of every table. You can also choose from several other index types:

Four column index types optimize specific types of queries on the indexed column.
Join indexes optimize queries that relate columns from two or more tables.

You will almost certainly want to supplement the default indexing by selecting one or more indexes for many of the columns in your database. You will also want to define join indexes for any table columns that are joined in a consistent way in user queries. Select indexes based on the size of your database, the disk space available, and the type of queries users submit.

Indexes are created on a specified table, or on a set of tables for join indexes. You cannot create an index on a view.