I am not a big expert on joins, but I think Oracle chooses Cartesian when
it thinks one of the row sources is going to return only one row.
On Sat, Mar 30, 2019 at 3:08 PM Orlando L <oralrnr@xxxxxxxxx> wrote:
List
When is it OK to do Cartesian joins?
1) It looks like during the star transformation while joining 2 or more
small result sets from dimension tables?
2) In an ordinary join, when one of the row sources is estimated to be 1
row with the other row source be several thousand? In this case, the
Cartesian will be just 1*no of rows in the other table.
Any explanation is helpful. thanks
Orlando.