The following table shows some of the common join operations you may encounter while using the Explain SQL window.
Operation | Option | Description |
---|---|---|
CONNECT BY |
A hierarchical self-join is performed on the output of the preceding steps. | |
MERGE JOIN |
A merge join is performed on the output of the preceding steps. | |
MERGE JOIN |
OUTER |
An outer join is implemented by a merge join. |
NESTED LOOPS |
A Nested Loops join is performed on the preceding steps. For each row in the upper result set, the lower result set is scanned to find a matching row. | |
MERGE JOIN |
SEMI |
Denotes a sort-merge semi-join. |
HASH JOIN |
SEMI |
Denotes a hash semi-join. |
MERGE JOIN |
ANTI |
Denotes a hash anti-join. |
NESTED LOOPS |
OUTER |
An outer join is implemented by a nested loop join. |
© ALL RIGHTS RESERVED. 使用条款 隐私 Cookie Preference Center