Merge join cartesian - all joins present - disable at databse level
Hi,
Running 11.2.0.1 on AIX.
Star queries are fine but when add additional dimesnion lookup table into the query joining a dimension to the associated lookup dimension generates a merge jojun cartesian cauisng query to be slower than without.
Can set at session level to disable this - can this be done at databse level.
Not sure why being generated - all joins presenet, joins on indexed columns.
Tried gatherting stats on percentage of the fact table as very large and thought is doen via 11g automatically in any case.
Many Thanks