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 you define an index, define it on the table columns that you have determined will improve retrieval performance.

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