Today in Gemma Is Great At Her Job: Partial indexes in get ignored in queries unless the query explicitly matches the filter condition from the index.

This episode is brought to you by No But Seriously RTFM, LLC

mongodb.com/docs/v4.4/core/ind

Follow

Aw crap, do I have to stop using the short $lookup syntax (localField/foreignField) too if I want to use the index?

Shoulda used sparse. I knew I shoulda just used sparse.

· · Web · 0 · 0 · 0
Sign in to participate in the conversation
Mastodon for Tech Folks

This Mastodon instance is for people interested in technology. Discussions aren't limited to technology, because tech folks shouldn't be limited to technology either!