An index is a search-basis key that is assigned to one or more columns of a table for the purpose of making retrievals from that table. An index can be either a B-tree index provided by HiRDB or a plug-in index provided by a plug-in. B-tree indexes are explained here; for an explanation of plug-in indexes, see Section 10.4 Preparations for using plug-ins in HiRDB.

When an index is defined, the table columns on which the index is to be based must be defined; columns that will improve retrieval performance should be selected.

Organization of this section

3.4.1 Basic structure of an index

3.4.2 Index row partitioning

3.4.3 Index page splitting

3.4.4 Exception key value

3.4.5 Defining an index for a table that contains data

3.4.6 Index key value no-lock