[Bug] nereids planner slower than old planner

[kobe6th]

Search before asking

• I had searched in the issues and found no similar issues.

Version

2.1

What's Wrong?

nereids planner slower than old planner

What You Expected?

fix this issue

How to Reproduce?

CREATE TABLE `test_tbl` (
  `id` VARCHAR(200) NULL,
  `create_time` DATETIME NULL,
  `amount` DECIMAL(21, 10) NULL,
  `num` VARCHAR(1020) NULL
) ENGINE=OLAP
UNIQUE KEY(`id`, `create_time`)
COMMENT 'OLAP'
DISTRIBUTED BY HASH(`id`) BUCKETS 10
PROPERTIES (
"replication_allocation" = "tag.location.default: 1"
);

SELECT count(id) FROM ( SELECT id, sum(amount) AS am, count(DISTINCT num) AS num FROM test_tbl GROUP BY id ) s1 WHERE 1 = 1 AND am >= 10 AND am <= 1000000 AND num >= 2 AND num <= 10000;

20000000 records in test_tbl
with set enable_nereids_planner=true, cost 11.40s
with set enable_nereids_planner=false, cost 4.66s

Anything Else?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct