Spotlight on Oracle 10.5

Chatta subito con l'assistenza

Spotlight on Oracle 10.5 - Release Notes

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.

Spotlight on Oracle 10.5 - Release Notes