Changeset: a5afe23a8505 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a5afe23a8505 Modified Files: sql/server/rel_optimizer.c Branch: default Log Message:
Call optimizer only when outer joins are available diffs (13 lines): diff --git a/sql/server/rel_optimizer.c b/sql/server/rel_optimizer.c --- a/sql/server/rel_optimizer.c +++ b/sql/server/rel_optimizer.c @@ -9694,7 +9694,8 @@ optimize_rel(mvc *sql, sql_rel *rel, int rel = rel_visitor_topdown(&v, rel, &rel_out2inner); if (gp.cnt[op_join]) rel = rel_visitor_bottomup(&v, rel, &rel_join2semijoin); - rel = rel_visitor_bottomup(&v, rel, &rel_push_join_down_outer); + if ((gp.cnt[op_left] || gp.cnt[op_right] || gp.cnt[op_full]) && gp.cnt[op_join]) + rel = rel_visitor_bottomup(&v, rel, &rel_push_join_down_outer); if (!gp.cnt[op_update]) rel = rel_join_order(&v, rel); if (gp.cnt[op_union]) _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list