Nonstop Database, HiRDB Version 9 UAP Development Guide
An index reduces the number of rows to be retrieved, thus reducing processing time. When a multicolumn index is used, fewer I/O accesses to the database are required than when a single index is used.
Retrieval performance is improved when an index is set on the following columns:
When many rows are to be updated or when the rows to be retrieved cannot be narrowed, the benefits of defining and using an index are not realized.
In the following cases, the benefits of using an index are not realized, because the number of rows to be retrieved cannot be reduced:
Because all related indexes are updated during data addition, updating, or deletion, the number of indexes affects processing efficiency. Processing time increases and efficiency declines, unless the number of indexes is minimized to the required number. An SQL error can also occur.
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.