<p dir="ltr">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.<br />
Thanks<br/> Herwig <div class="gmail_quote">Op 20 jun. 2016 3:42 p.m. schreef "Tom Lane" <<a
href="mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>>:<brtype="attribution" /><blockquote class="gmail_quote"
style="margin:00 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Herwig Goemans <<a
href="mailto:herwig.goemans@gmail.com">herwig.goemans@gmail.com</a>>writes:<br /> > Is there anyone who can help
sothat the mixed query has the same or<br /> > equivalent execution plan (performance) as the ansi query ?<br /><br
/>I think you need to raise join_collapse_limit and/or from_collapse_limit.<br /><br />
regards,tom lane<br /></blockquote></div>