Hi, this is a mailing-list repost of StackOverflow question
"pouchdb-find: can $in / $or queries use indexes?" [1]
I noticed that queries using $in, such as:
"type": {"$in": ["a", "b"]}
... fail to use the existing relevant index (pouchdb-find warns
"no matching index found, create an index to optimize query time").
StackOverflow user markwatsonatx suggested adding to my query
"_id": {"$gt": 0}
... and indeed I no longer get index warnings with it.
Is this expected behavior? Can anyone explain what's going on? Thanks!
[1]
http://stackoverflow.com/questions/40686383/pouchdb-find-can-in-or-queries-use-indexes
