Re: self-join runs forever
From: Jim <jimmy.liew_at_ogilvy.com>
Date: 8 May 2002 18:32:09 -0700
Message-ID: <e7d269ce.0205081732.7ca5d35b_at_posting.google.com>
Date: 8 May 2002 18:32:09 -0700
Message-ID: <e7d269ce.0205081732.7ca5d35b_at_posting.google.com>
Since this is a group on a large table which joins back to itself, I think driving table is not an issue?
> Look at the nested loop, make sure the right table is driving. Use the
> LEADING, USE_NL or other hint to force the proper order.
>
> Mike
Received on Thu May 09 2002 - 03:32:09 CEST