Changeset: 5757e2e21367 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=5757e2e21367 Modified Files: sql/server/rel_optimizer.c Branch: Jun2020 Log Message:
Small performance fix, joins with comple cmp expressions should be pushed up early diffs (12 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 @@ -883,7 +883,7 @@ order_joins(mvc *sql, list *rels, list * /* complex expressions may touch multiple base tables * Should be pushed up to extra selection. * */ - if (cje->type != e_cmp || !is_complex_exp(cje->flag) || !find_prop(cje->p, PROP_HASHCOL) /*|| + if (cje->type != e_cmp || is_complex_exp(cje->flag) || !find_prop(cje->p, PROP_HASHCOL) /*|| (cje->type == e_cmp && cje->f == NULL)*/) { l = find_one_rel(rels, cje->l); r = find_one_rel(rels, cje->r); _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list