5.2.5 How to check the index used during execution of an SQL statement
You can check which index was used during execution of an SQL statement by checking the access path. For details about access paths, see the following sections:
-
How to check access paths
-
Information displayed in access paths
See (b) Information related to indexes in (1) Information related to table retrieval methods and indexes in 6.1.5 Information displayed in the details view.
By checking access paths, you can find out whether indexes were used as intended.
If an index is defined for a target table, it is used for search processing according to the specified search condition. However, depending on the specified search condition, the index might not be used or a different index might be used unexpectedly. If the results obtained by the above check indicate that the index was not used as intended, the specified search condition or index definition might not be appropriate. In such a case, consider changing the index definition or the search condition.
If the index definition needs to be changed, the application program developer must request that the HADB system designer or system administrator change the index definition.