Hi Nuno,
have you tried to disable hash joins explicitly via
hash_join_enabled = false ?
Could you forward Anjo's explanation?
Regards,
Ed
>
>
> SAS=2M, CACHING=50, ADJ=10.
> My HASH was 10M, then dropped it down
> all the way to 260K, at which stage it
> threw out the MERGE JOIN CARTESIAN and went back
> to HASH JOIN only. So I threw it out completely
> (default 0), which would have made it 2M given
> that SAS dependency. But the MERGE JOIN CARTESIAN
> did disappear with HASH defaulted, even though it was
> there while I tried HASH 2M! More mystery...
>
> So far, Anjo Kolk has provided me with the most plausible
> explanation and it has nothing to do with any of
> these parameters...
>
> Cheers
> Nuno Souto
> [EMAIL PROTECTED]
> http://www.users.bigpond.net.au/the_Den
> ----- Original Message -----
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Shevtsov, Eduard
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
