Loading...

XML

Word

Printable

JSON

Type: Improvement
Resolution: Unresolved
Priority: Major - P3
Fix Version/s: None
Affects Version/s: None
Component/s: Querying
Labels:
None
Environment:

Hide
mongod --version
db version v3.4.7
git version: cf38c1b8a0a8dca4a11737581beafef4fe120bcd
OpenSSL version: OpenSSL 1.0.1e-fips 11 Feb 2013
allocator: tcmalloc
modules: none
build environment:
    distmod: rhel70
    distarch: x86_64
    target_arch: x86_64

cat /etc/redhat-release
CentOS Linux release 7.0.1406 (Core)

Show
mongod --version db version v3.4.7 git version: cf38c1b8a0a8dca4a11737581beafef4fe120bcd OpenSSL version: OpenSSL 1.0.1e-fips 11 Feb 2013 allocator: tcmalloc modules: none build environment:     distmod: rhel70     distarch: x86_64     target_arch: x86_64 cat /etc/redhat-release CentOS Linux release 7.0.1406 (Core)

Assigned Teams:

Query Optimization
Case:
Confidence Status:
None
Work Order:
3
CAR Domain/s:
None

Aha! Reference:
None
Tracking Level:
None
Risk Status:
None
Exec Notes:
None
Goal Name(s):
None
Goal Link:
None

The query explainer don't consider the keys in $elemMatch expression when to decide index boundaries. Instead, it scans all entries in the selected index.

is duplicated by

SERVER-27522 query optimizer does not choose appropriate partial index when matching "expression" is in $elemMatch

Closed

is related to

SERVER-26413 Hinting an incompatible partial index can return incomplete results

Backlog

SERVER-17853 Allow more complex expressions to be specified in partial index document filter

Backlog

Assignee:: [DO NOT USE] Backlog - Query Optimization
Reporter:: Alex Hu
Participants:: [DO NOT USE] Backlog - Query Optimization, Alex Hu, David Storch
Votes:: 4 Vote for this issue
Watchers:: 20 Start watching this issue

Created:: Jan 04 2018 08:25:37 AM UTC
Updated:: Dec 06 2022 03:42:35 AM UTC

Details

Description

Attachments

Issue Links

Forms

Activity

People

Dates