立即与支持人员聊天
与支持团队交流

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

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级