Chat now with support
Chat with Support

Spotlight on Oracle 11.0 - 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 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