Loading...

XML

Word

Printable

JSON

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 )

depends on

SERVER-1673 Allow distinct to use indexes

SERVER-11939 Implement advanceToNextUniqueKey access method on btree

is duplicated by

SERVER-29244 CLONE - distinct cheat with indexes

is related to

SERVER-13271 remove surplus projection from distinct

related to

SERVER-12297 Distinct - nscanned for $in and $or greater than nscannedObjects

SERVER-9507 Optimize $sort+$group+$first pipeline to avoid full index scan

(1 related to)

Participants:: Adam Szpakowski, Ali Watters, Benjamin Jackman, Eliot Horowitz, Githook User, hari.khalsa@10gen.com, Hugo Lopes Tavares, Jason R. Coombs, Kevin McCarthy, Richard Uren, Sebastian Paul, Sergey Alaev, Tuner, wouter alleweireldt