Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Tech Request]: [OPT] Common Subexpression Elimination #12570

Closed
1 task done
aunjgr opened this issue Nov 8, 2023 · 0 comments
Closed
1 task done

[Tech Request]: [OPT] Common Subexpression Elimination #12570

aunjgr opened this issue Nov 8, 2023 · 0 comments
Assignees
Labels
Milestone

Comments

@aunjgr
Copy link
Contributor

aunjgr commented Nov 8, 2023

Is there an existing issue for the same feature request?

  • I have checked the existing issues.

Is your feature request related to a problem?

No response

Describe the feature you'd like

Determine common subexpressions and subtrees in query plan, then use that information to save both IO and computing power.

It affects:

  • expression level (TPC-H Q1)
  • node level
    • self join (TPC-H Q21)
    • subquery/view (TPC-H Q2 Q11 Q15 Q21)
    • materialized view

Describe implementation you've considered

No response

Documentation, Adoption, Use Case, Migration Strategy

No response

Additional information

No response

@sukki37 sukki37 added this to the 1.2.0 milestone Nov 8, 2023
@sukki37 sukki37 added kind/tech-request New feature or request and removed kind/feature labels Nov 8, 2023
@sukki37 sukki37 changed the title [Feature Request]: [OPT] Common Subexpression Elimination [Tech Request]: [OPT] Common Subexpression Elimination Nov 8, 2023
@aunjgr aunjgr modified the milestones: 1.2.0, Backlog Nov 11, 2023
@sukki37 sukki37 modified the milestones: Backlog, Future Issue Pool Nov 14, 2023
@sukki37 sukki37 modified the milestones: Future Issue Pool, Backlog Jul 1, 2024
@aunjgr aunjgr closed this as completed Nov 6, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants