RE: Optimizer and block size changes = trouble...

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
> nsouto_at_nsw.bigpond.net.au
> 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: EShevtsov_at_flagship.ru

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: ListGuru_at_fatcity.com (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).