Loading...

XML

Word

Printable

JSON

Had a compound index on

{ "lineitems.returnflag":1, "lineitems.linestatus":1 }

where lineitems is an array.

Did db.orders.distinct("lineitems.returnflag") which caused a collection scan.

Non-multikey correctly used the index.

depends on

SERVER-12869 Index null values and missing values differently

is duplicated by

SERVER-9640 Distinct command does not use covering multi-key indexes.

SERVER-20989 Distinct not uses indexes

SERVER-27060 Distinct not using the index on an indexed array field

Participants:: Asya Kamsky, Danny Couture, David Storch, Githook User, hari.khalsa@10gen.com, Ian Boros, Konstantin Bodnia