MongoDB compound index with multi-key field and range query

Question

The question has been previously asked in another thread (MongoDB - Multi-key and Compound) and there is currently no solution from MongoDB. Has anyone developed a successful workaround either through indexing or document design?

Example document:

{
  timestamp: Timestamp(1234123123,0),
  values : [
     {field1:"somevalue", field2:"otherValue"},
     {field1:"somevalue2", field2:"otherValue2"}
  ]
}

Our index specifically is: timestamp : -1, values.field2:1 and the explain shows that the lower bound of the timestamp is ignored.

Community · Accepted Answer · 2017-05-23 12:27:25Z

0

if you have complex object you need index values with defining path to this value, like that values.field2:1

db.collectionName.ensureIndex( { timestamp: -1}, {values.field2: 1} )

Also I had some kind of same question some time ago. Check out here: Mongo and Java: Create indexes for aggregation framework

edited May 23, 2017 at 12:27

CommunityBot

11 silver badge

answered Jun 6, 2014 at 18:59

Lugaru

1,4603 gold badges25 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3707362 Over a year ago

We had already created the index in the manner that you suggested.

Collectives™ on Stack Overflow

MongoDB compound index with multi-key field and range query

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related