-
Notifications
You must be signed in to change notification settings - Fork 1k
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
Covering indexes for Mango JSON indexes #4413
Labels
Comments
This was referenced Apr 27, 2023
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Summary
Provide the ability for Mango to answer a query only using an index, when that index contains all fields needed by a query.
This should speed up these queries significantly -- PoC benchmarks indicate 2-5x speedups dependent on the number of documents that need to be read from primary data. (5x seen at p90 response times between 100 and 500 documents read from primary data for a simple one-field query, on a 2022 MacBook Pro using k6.io).
Desired Behaviour
Described in #4410.
Possible Solution
Described in #4410.
Additional context
None needed beyond RFC.
General PRs
mango_cursor_view:choose_best_index/2
)index_rows_read
into mango execution stats._explain
.The text was updated successfully, but these errors were encountered: