[SERVER-1207] query plan recording may inappropriately record a following or clause Created: 08/Jun/10  Updated: 12/Jul/16  Resolved: 01/Sep/10

Status: Closed
Project: Core Server
Component/s: Index Maintenance
Affects Version/s: None
Fix Version/s: 1.7.0

Type: Bug 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   

Say we have {$or:[

{a:1}

,

{b:2,c:3}

]}. On the initial query most of the result may come from the

{a:1}

clause, and only a few results from the

{b:2,c:3}

clause. The selection of index

{b:1}

or

{c:1}

will be based on less data than it would be otherwise, and arguably shouldn't be recorded for future operations.



 Comments   
Comment by auto [ 01/Sep/10 ]

Author:

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

Message: SERVER-1207 be more conservative recording a successful query plan when part of an or clause
http://github.com/mongodb/mongo/commit/a6e3b04263d32885d4462d4b34c7f77badef820e

Comment by auto [ 01/Sep/10 ]

Author:

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

Message: SERVER-1207 be more conservative recording a successful query plan when part of an or clause
http://github.com/mongodb/mongo/commit/a6e3b04263d32885d4462d4b34c7f77badef820e

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