I've tried this kind of compound index in my app, that use spring data too, and worked properly.
You only have to correct the index definition in @CompoundIndex
annotation:
@CompoundIndex(name = "aid_bid_idx", def = "{'id' : 1, 'b.id' : 1}")
@Document(collection = "doc_a")
public class A {
@Field("id")
private Integer id;
@Field("b")
private Collection<B> b;
...
}
public class B {
@Field("id")
private Integer id;
...
}
If you run a query with explain (like the follows) in mongo shell, you'll see that the index *aid_bid_idx* will be used.
db.doc_a.find({ "id" : 1, "b.id" : 1}).explain()
The result will be something like this:
{
"cursor" : "BtreeCursor aid_bid_idx",
...
}
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…