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

sql: support "point" lookups using indexes #2140

Closed
petermattis opened this issue Aug 18, 2015 · 0 comments
Closed

sql: support "point" lookups using indexes #2140

petermattis opened this issue Aug 18, 2015 · 0 comments
Assignees
@petermattis
Milestone
Beta

Comments

@petermattis
Copy link
Collaborator

Currently the query planner only performs a single scan of a table or index (limiting the range of the scan when possible). Consider a query like SELECT * FROM foo WHERE bar IN (1, 2, 3, 4, 5). If an appropriate index is available, the query planner should perform "point" lookups of the index rows.
@petermattis petermattis self-assigned this Aug 18, 2015
@petermattis petermattis added this to the Beta milestone Aug 18, 2015
@petermattis petermattis mentioned this issue Aug 18, 2015
Closed
@jess-edwards jess-edwards mentioned this issue Aug 20, 2015
Closed
78 tasks
@petermattis petermattis mentioned this issue Aug 25, 2015
Merged
@petermattis petermattis mentioned this issue Aug 27, 2015
Merged
petermattis added a commit that referenced this issue Aug 28, 2015
@petermattis
Replace qvalueRange and qvalueRangeMap with analyzeExpr.
cc7731b 
Working towards #2140 and #2142.
@petermattis petermattis mentioned this issue Aug 28, 2015
Merged
petermattis added a commit that referenced this issue Aug 28, 2015
@petermattis
Add support for scanning multiple spans for a single index.
ba35f7b 
Index selection now creates multiple independent spans of the index that
must be scanned. Multiple spans are created for expressions like "a
IN (1, 2, 3)" and "a = 1 OR a = 2 or a = 3" (these are equivalent).

Fixes #2140.
See #2142.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@petermattis petermattis

Labels
None yet
Projects
None yet
Milestone
Beta
Development

No branches or pull requests
1 participant
@petermattis