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





Oracle LazyDBA home page