Look in Performance tuning guide "Using Plan Stability"

Dustin Hayden wrote:

>What about setting hash_join_enabled to flase?
>
>
>-----Original Message-----
>From: emerson fabiano [mailto:oracledba-ezmlmshield-x59549501.[Email address protected]
>Sent: Friday, June 30, 2006 10:46 AM
>To: LazyDBA Discussion
>Subject: join cartesian
>
>Hi,
>I forgot to say that the sentence is hardcoded inside de application :(
>I´ve created an outline for this statement but i need a more generic
>solution if possible.
>
>tks
>emerson
>
>
>
>
>
>>Hi,
>>
>>Is it possible to disable join cartesians for oracle 10.1.0.5?
>>I have a plan that the best option is nested loops (driven table with
>>5 rows) but the optimizer tries a merge join cartesian with other index.
>>tks
>>
>>
>
>
>
>
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
>
>
>

Oracle LazyDBA home page