[SERVER-1206] $or hint does not use index ranges expressed in or clauses Created: 08/Jun/10  Updated: 12/Jul/16  Resolved: 09/Jun/10

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 1.5.3

Type: New Feature Priority: Major - P3
Reporter: Aaron Staple Assignee: Aaron Staple
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Participants:

 Description   

Decide whether this is necessary and if it is then implement it.



 Comments   
Comment by auto [ 09/Jun/10 ]

Author:

{'login': 'astaple', 'name': 'Aaron', 'email': 'aaron@10gen.com'}

Message: SERVER-1206 $or hint
http://github.com/mongodb/mongo/commit/828ca29ab4e58f3a6e0bc8702006474afda66ac9

Comment by auto [ 09/Jun/10 ]

Author:

{'login': 'astaple', 'name': 'Aaron', 'email': 'aaron@10gen.com'}

Message: SERVER-1206 $or hint
http://github.com/mongodb/mongo/commit/828ca29ab4e58f3a6e0bc8702006474afda66ac9

Comment by Eliot Horowitz (Inactive) [ 09/Jun/10 ]

yea - definitely needed

Comment by Aaron Staple [ 09/Jun/10 ]

(And contrary to my note in the description It's probably necessary

Comment by Aaron Staple [ 09/Jun/10 ]

So if I do find( {$or:[

{a:1,b:3}

,

{a:2,b:4}

]} ).hint(

{a:1}

) it will scan the a index from minkey to maxkey rather than just values of 1 and 2. Not a lot of work to implement this, I just wanted to separate it out.

Comment by Eliot Horowitz (Inactive) [ 09/Jun/10 ]

Can you give an example

Generated at Thu Feb 08 02:56:23 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.