Re: unexpected merge cartesian join

There are no temporary tables involved and recollect fresh statistics was the first thing I did when I discovered the problem. But it didn't help.
This problem appeared when we upgrade the database from 9.2.0.6 to 9.2.0.7
I will try to study Jonathan's suggestions (and his book as well..) to understand better.
What I found somewhat ironic is that I always tried, as a developer, to avoid
using in my programs << select * >> since I was thinking that, from the performance point of view, it was better practice to use only the columns required.
In this case, however, using select * performs better than the other approach...

Thanks to all of you very much for the answers and the help

Bye
Nicola Received on Fri Dec 02 2005 - 02:35:35 CST