[SERVER-12873] dbtest for plan ranking Created: 24/Feb/14  Updated: 11/Jul/16  Resolved: 26/Feb/14

Status: Closed
Project: Core Server
Component/s: Querying
Affects Version/s: 2.6.0-rc0
Fix Version/s: 2.6.0-rc1

Type: Task Priority: Major - P3
Reporter: David Storch Assignee: hari.khalsa@10gen.com
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Participants:

 Description   

We currently don't have any tests for plan ranking. Such tests would specify the indices, data, and query, and then show that ranking chooses the right plan.

Some interesting cases include, but are not limited to:

  • Two plans hit EOF at the same time, but one is covered. Make sure that we prefer the covered plan.
  • A query where using an index requires us to look at the entire collection. In this case, a collection scan will hit EOF first and should win.
  • No plan produces any results or hits EOF. In this case we should never choose an index intersection solution.
  • No plan produces any results or hits EOF. In this case we should prefer covered solutions to non-covered solutions.
  • We have an index on "a" which is somewhat selective and an index on "b" which is highly selective (will cause an immediate EOF). Make sure that a query with predicates on both "a" and "b" will use the index on "b".


 Comments   
Comment by Githook User [ 26/Feb/14 ]

Author:

{u'username': u'hkhalsa', u'name': u'Hari Khalsa', u'email': u'hkhalsa@10gen.com'}

Message: SERVER-12873 add more plan ranking dbtests
Branch: master
https://github.com/mongodb/mongo/commit/fafbd01bda9ef5a0969a56365d0af9ce4a4fc689

Comment by Githook User [ 25/Feb/14 ]

Author:

{u'username': u'hkhalsa', u'name': u'Hari Khalsa', u'email': u'hkhalsa@10gen.com'}

Message: SERVER-12873 begin dbtest file for plan ranking, add force-ixisect flag for qa
Branch: master
https://github.com/mongodb/mongo/commit/03b5eae78c653d7eb11df4ce26b9b28833e95e62

Generated at Thu Feb 08 03:29:54 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.