always_anti_join NESTED

From: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Wed, 31 May 2000 11:24:33 -0300
Message-Id: <10514.107297@fatcity.com>

Orasnap suggests that NESTED_LOOPS is slower than HASH.

Is this true?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des syst=E8mes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique=20
Maritimes Region, DFO      | R=E9gion des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>=20 Received on Wed May 31 2000 - 09:24:33 CDT

always_anti_join NESTED_LOOPS or HASH?