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

Oracle LazyDBA home page