[SERVER-29244] CLONE - distinct cheat with indexes Created: 17/May/17  Updated: 17/May/17  Resolved: 17/May/17

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

Type: Improvement Priority: Major - P3
Reporter: stone [X] Assignee: hari.khalsa@10gen.com
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
depends on SERVER-1673 Allow distinct to use indexes Closed
depends on SERVER-11939 Implement advanceToNextUniqueKey acce... Closed
Duplicate
duplicates SERVER-2094 distinct cheat with indexes Closed
Related
related to SERVER-12297 Distinct - nscanned for $in and $or g... Closed
related to SERVER-9507 Optimize $sort+$group+$first pipeline... Closed
is related to SERVER-13271 remove surplus projection from distinct Closed
Participants:

 Description   

Right now distinct will pull data out of indexes, but will scan the entire thing.
Can skip whole regions where the key is the same

Correct way to implement is probably adding a method to a btree bucket like

getDisinctKeys( int keyOffset )



 Comments   
Comment by Kelsey Schubert [ 17/May/17 ]

Hi cnStoneFang,

I'm closing this ticket as a duplicate of SERVER-2094, since it's not clear what work is being described by this ticket that wasn't completed in SERVER-2094. If you have a specific request regarding this issue please let us know so we can consider it.

Regards,
Thomas

Generated at Thu Feb 08 04:20:18 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.