Querying over two indexed properties is painfully slow when using ‘OR’. This query takes about 40 seconds to execute with 500 000 records in the bucket: SELECT device FROM default WHERE device.cashDrawerOpenCount > 1000000 OR device.tempMaxBoard > 10000000 Execution time: 40s Runnning separately…

Low performance when using 'OR' in WHERE clause

zahiduysal May 18, 2016, 1:13pm 9

I want to you examine forum topic from hyperlink.

Topic		Replies	Views
Slow N1QL search on using OR condition SQL++	16	1055	September 11, 2020
"OR" 100 times slower than "AND" SQL++ n1ql	9	1654	January 6, 2017
N1QL Count() slow with WHERE SQL++ n1ql	15	10558	October 24, 2016
Improving query with multiple OR clauses SQL++ n1ql , index	25	4700	February 12, 2018
N1QL Index with an OR statement SQL++	13	3192	April 9, 2016