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	1785	October 24, 2013
ORDER BY with OR disjunctions is very slow, even when order field is indexed SQL++ n1ql	4	1528	October 26, 2021
Multiple Array Search In Single Query Does Not Support Indexing on `OR` Operator SQL++ query , n1ql , index	3	1372	October 5, 2017
Why does my query not use the index? SQL++ n1ql , index	4	1640	October 5, 2016
N1QL Index with an OR statement SQL++	13	3346	April 9, 2016