You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@couchdb.apache.org by GitBox <gi...@apache.org> on 2020/05/01 16:18:56 UTC

[GitHub] [couchdb] roedoejet commented on issue #2856: $or and $in operators do not seem to be using indices

roedoejet commented on issue #2856:
URL: https://github.com/apache/couchdb/issues/2856#issuecomment-622454592


   > @roedoejet `json` indexes basically don't have any support for the `$in` operator today - they require some kind of range query in the selector in order to use an index.
   > 
   > One option is to install the [text index plugin](https://docs.couchdb.org/en/master/ddocs/search.html), which will give you native `$in` support via Lucene indexes.
   
   OK, thanks for this. I would love to see this documented [here](https://docs.couchdb.org/en/2.2.0/api/database/find.html#condition-operators). There is already a note about the regex operator not accepting indices, so I assumed that was the only operator to note wrt indices.
   
   What about my example with `$or`?


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org