Chat now with support
Chat with Support

Spotlight on Oracle 10.7 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Spotlight on MySQL Troubleshooting: Connection Problems

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

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating