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.

Sign up for GitHub

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

Jump to bottom

Add query optimization #5

Open
michaelmior opened this issue May 24, 2019 · 2 comments
Open

Add query optimization #5

michaelmior opened this issue May 24, 2019 · 2 comments

Comments

@michaelmior
Copy link
Member

The tool could also be useful for explaining some simple query optimizations. For example, pushing a filter through a join. This would probably best take the form of a series of optimization rules which can be toggled on and off with some clear way to see how the expression changes.
@michaelmior
Copy link
Member Author

First pass of optimization is in #1657.

Future useful optimizations could involve join order selection and others.

@michaelmior
Copy link
Member Author

SQLGlot has a good list of other possible optimizations.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@michaelmior