5.5 Table joining methods
There are two table joining methods:
-
Nested loop join
-
Hash join
This section explains these two joining methods and their characteristics.
HADB automatically determines the table joining method to use. You can find out which join method was used by checking the access path after the SQL statement was executed. For details about access paths, see the following subsections:
-
How to check access paths
-
Information that is displayed as access paths
See (27) Table joining methods in 6.1.4 Information displayed in the tree view.
- Note
-
In the case of a joined table, you can specify the join method in a join method specification. For details about join method specifications, see Specification format and rules for join method specifications in the manual HADB SQL Reference.
- Organization of this section