An index is a key created on the basis of values in a specified column in a table to improve processing speed during data retrieval. Using indexes can reduce the number of I/O operations during retrievals.

This section explains the implications on UAP design of using indexes. For details about index definition, see the HiRDB Version 8 Installation and Design Guide.

Organization of this section

4.1.1 Indexes and processing time

4.1.2 Index priority

4.1.3 Changing indexes during retrieval