I have been testing indexes in N1QL with OR statements and have unexpected results: I have objects in the database, all which contain a “tId” field, and I have created an index as: create index tId_IX on default(tId); When I run EXPLAIN on a statement like select * from default where tId = 'xyz'…

N1QL Index with an OR statement

MikeMaik April 9, 2016, 10:31am 14

Thank you so much. That did the trick.

Topic		Replies	Views
Indexes not used in OR query SQL++	1	1764	October 24, 2013
Priority in N1QL indexes SQL++	7	3736	February 17, 2015
Improving query with multiple OR clauses SQL++ n1ql , index	25	4847	February 12, 2018
Non matching index in N1QL SQL++ query , n1ql , index	2	1028	November 4, 2017
Multiple Array Search In Single Query Does Not Support Indexing on `OR` Operator SQL++ query , n1ql , index	3	1339	October 5, 2017