On Fri, Jul 28, 2000 at 09:39:29AM -0800, Lyall Barbour wrote:
> Well, if everything was initialized in the beginning as far as the init.ora
> file goes, you're probably doing a Nested Loop anti-join. I'd suggest
> inserting ALWAYS_ANTI_JOIN=HASH (or MERGE)
>
> Just a little tip from your Uncle Lyall!
>
> Of course to do this.... do you need a bounce, or can you do ALTER
> SESSION.... I think you can do alter session. I know you can use a hint in
> your delete /*+ HASH_AJ */
*sigh* Oracle is a beast and CBO should be renamed to
"Confusing Bastard Optimizer"
Received on Fri Jul 28 2000 - 12:44:27 CDT
