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 OS/400. 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:
Binary radix tree indexes provide a specific order to the rows of a table. The database manager uses them to:
Encoded vector indexes do not provide a specific order to the rows of a table. The database manager only uses these indexes to improve performance.
An encoded vector access path works with the help of encoded vector indexes and provides access to a database file by assigning codes to distinct key values and then representing these values in an array. The elements of the array can be 1, 2, or 4 bytes in length, depending on the number of distinct values that must be represented. Because of their compact size and relative simplicity, encoded vector access paths provide for faster scans that can be more easily processed in parallel.
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, go to the DB2 UDB for iSeries webpages.
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.