[Enhancement] (Nereids) speed up clickbench query

[morrySnow]

Search before asking

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

Description

speed up clickbench query on Nereids, at least tie with legacy one

• [Enhancement] (Nereids) use zonemap to speed up count, min and max #14464
• [Enhancement] (Nereids) bucket prune #14465
• [Enhancement] (Nereids) remove useless group by expr #14466
• [Enhancement] (Nereids) remove useless project plan #14467
• [Enhancement] (Nereids) refactor agg normalize to eliminate materialize expand #14468
• [Enhancement] (Nereids) use one stage agg when aggregate by key column #14469

Solution

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