The one record you need in a collection


{ "_id" : { "$oid" : "4d01560d9115b1e86711baa4" }, "_changeSetId" : "4d01560c9115b1e83611baa4", "keys" : [ { "keyname" : "TICKER+MIC", "keyvalue" : "FNCAMA", "pointers" : [ { "sourceId" : "4d0156099115b1e82c11baa4", "sourceDatasetId" : "MGFN9951524d01560c9115b1e83611baa4", "sourceKeyExpressionId" : "MGFN995152" } ] }, { "keyname" : "MIC+CURRENCY", "keyvalue" : "CAMAUSD", "pointers" : [ { "sourceId" : "4d0156099115b1e82c11baa4", "sourceDatasetId" : "MGFN9951524d01560c9115b1e83611baa4", "sourceKeyExpressionId" : "MGFN995152" } ] }, { "keyname" : "ISIN", "keyvalue" : "US31416BQD37", "pointers" : [ { "sourceId" : "4d0156099115b1e82c11baa4", "sourceDatasetId" : "MGFN9951524d01560c9115b1e83611baa4", "sourceKeyExpressionId" : "MGFN995152" } ] }, { "keyname" : "CUSIP", "keyvalue" : "31416BQD3", "pointers" : [ { "sourceId" : "4d0156099115b1e82c11baa4", "sourceDatasetId" : "MGFN9951524d01560c9115b1e83611baa4", "sourceKeyExpressionId" : "MGFN995152" } ] }, { "keyname" : "ID_BB_UNIQUE", "keyvalue" : "MGFN995152", "pointers" : [ { "sourceId" : "4d0156099115b1e82c11baa4", "sourceDatasetId" : "MGFN9951524d01560c9115b1e83611baa4", "sourceKeyExpressionId" : "MGFN995152" } ] } ] }

then ensureIndex on {"keys.keyvalue":1}

then do the search

db.mycol.find({ "keys.keyname" : "MIC+CURRENCY" , "keys.keyvalue" : "CAMAUSD" , "$or" : [ { "keys.keyname" : "ISIN" , "keys.keyvalue" : "US31416BQD37"} , { "keys.keyname" : "CUSIP" , "keys.keyvalue" : "31416BQD3"} , { "keys.keyname" : "ID_BB_UNIQUE" , "keys.keyvalue" : "MGFN995152"}]})

Should return nothing - then drop the index and try again