5.1 How to retrieve tables
HADB supports the following three retrieval methods for searching tables:
-
Table scan
-
Index scan
-
Key scan
HADB determines the table retrieval method automatically. You can check which method was used when executing a SQL statement by checking the access path. For details about access paths, see the following subsections:
-
How to check access paths
-
Information displayed in access paths
See (20) Table retrieval method in 6.1.4 Information displayed in the tree view.
- Note
-
By using an index specification, you can specify the index to use when retrieving a table, or prevent the use of indexes for a particular retrieval. For details about index specifications, see Specification format and rules for index specifications in the manual HADB SQL Reference.
Note that table here refers to a base table.
- Organization of this section