Use a hint.


-----Original Message-----
From: emerson fabiano
[mailto:oracledba-ezmlmshield-x27106025.[Email address protected]
Sent: Friday, June 30, 2006 10:09 AM
To: LazyDBA Discussion
Subject: join cartesian

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

Emerson


--------
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