Chat now with support
Chat mit Support

Spotlight on Oracle 10.4 - Release Notes

Join Operations

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.

 

Related Topics

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen