Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> NL & Hash Outer Join question

NL & Hash Outer Join question

From: rjamya <rjamya_at_gmail.com>
Date: Thu, 25 Jan 2007 15:59:06 -0500
Message-ID: <9177895d0701251259w40e64db1ua1f48608396f6533@mail.gmail.com>


What might cause a query using NL (in 9204) use Hash Outer Join (in 9208) when all optimizer and memory parameter being same. I checked optimizer parameter values using 10053 trace.

The tables involved are analyzed identical, contain identical data (9208 was cloned from 9204), they run on identical servers and only one person logs in and runs the test. Memory sizes etc are all identical.

Any ideas?
Rjamya



Got RAC?

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jan 25 2007 - 14:59:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US