Re: 4 join methods?

[Sam Roberts]

I did have to RTFM -   A cluster join is nothing more than a nested loops join involving two tables that are stored together in a cluster. Because each row from the dept table is stored in the same data blocks as the matching rows in the emp table, Oracle can access matching rows most efficiently   Sam ----- Original Message ----- From: Vadim Gorbounov To: Multiple recipients of list ORACLE-L Sent: Friday, June 01, 2001 6:25 PM Subject: RE: 4 join methods? Hi, DBAs, RTFM is so boring, but... There is cut&paste from "Oracle8i Designing and Tuning for Performance"    The Optimizer      Optimizing joins   Join Operations   To join each pair of row sources, Oracle must perform one of these operations: Nested Loops (NL) Join Sort-Merge Join Hash Join (not available with the RBO) Cluster Join Cheers, Vadim Gorbounov Oracle DBA