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
Indexes not used in OR query SQL++	1	1774	October 24, 2013
Why does my query not use the index? SQL++ n1ql , index	4	1616	October 5, 2016
N1QL Index with an OR statement SQL++	13	3312	April 9, 2016
Multiple Array Search In Single Query Does Not Support Indexing on `OR` Operator SQL++ query , n1ql , index	3	1351	October 5, 2017
"OR" 100 times slower than "AND" SQL++ n1ql	9	1750	January 6, 2017