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

Better to scan with OR filter than to Union multiple identical scans with individual filters #1004

Closed
MMcM opened this issue Jul 28, 2020 · 1 comment
Closed

Better to scan with OR filter than to Union multiple identical scans with individual filters #1004

MMcM opened this issue Jul 28, 2020 · 1 comment
Assignees
@MMcM
Labels
enhancement New feature or request planner Related to the query planner

Comments

@MMcM
Copy link
Contributor

MMcM commented Jul 28, 2020 

x = 1 AND (y = 3 OR y = 4 OR y > 10)

today becomes

Index(x EQUALS 1) | y EQUALS 3 ∪ Index(x EQUALS 1) | y EQUALS 4 ∪ Index(x EQUALS 1) | y GREATER_THAN 10

when it is pretty easy to get

Index(x EQUALS 1) | Or(y EQUALS 3, y EQUALS 4, y GREATER_THAN 10)
@MMcM MMcM added enhancement New feature or request planner Related to the query planner labels Jul 28, 2020
@MMcM MMcM self-assigned this Jul 28, 2020
@MMcM
Copy link
Contributor Author

MMcM commented Jul 28, 2020

Some cases of #1000 then do not require the full power of #991.

normen662 added a commit that referenced this issue Jul 30, 2020
@normen662
Merge pull request #1005 from MMcM/filtered-or-versus-unioned-filters
f71d1e1 
Resolves #1004: Better to scan with OR filter than to Union …
@MMcM MMcM mentioned this issue Jun 21, 2021
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@MMcM MMcM

Labels
enhancement New feature or request planner Related to the query planner
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@MMcM