Indexes

An index is a set of pointers to rows of a base table. Each index is based on the values of data in one or more table columns. An index is an object that is separate from the data in the table. When an index is created, the database manager builds this structure and maintains it automatically.

An index has a name and may have a different system name. The system name is the name used by i5/OS. Either name is acceptable wherever an index-name is specified in SQL statements. For more information, see CREATE INDEX.

The database manager uses two types of indexes:

An index is created with the CREATE INDEX statement. For more information about creating indexes, see CREATE INDEX.

For more information about accelerating your queries with encoded vector indexes Link outside of Information Center, go to the DB2 UDB for iSeries webpages.