Thanks for the feedback. At the moment, we match indexes in very basic cases and don’t use an index in the case of multiple predicates in the WHERE clause. Something we will look into into future DPs.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| N1QL Index with an OR statement | 13 | 3274 | April 9, 2016 | |
| Non matching index in N1QL | 2 | 1028 | November 4, 2017 | |
| Multiple Array Search In Single Query Does Not Support Indexing on `OR` Operator | 3 | 1339 | October 5, 2017 | |
| Why does my query not use the index? | 4 | 1606 | October 5, 2016 | |
| Low performance when using 'OR' in WHERE clause | 16 | 3766 | March 19, 2019 |