Your help is very much appreciated, I did that already short after I sent the mail and it resolved the issue. However I do not understand why there is a difference in behaviour between ansi join and comma like join. Thanks Herwig
Herwig Goemans <herwig.goemans@gmail.com> writes: > Is there anyone who can help so that the mixed query has the same or > equivalent execution plan (performance) as the ansi query ?
I think you need to raise join_collapse_limit and/or from_collapse_limit.
