Hi, i have a join query that ho very slow. I use the key for join but query continue to use 5 second. SELECT * FROM bucket doc_type1 JOIN bucket doc_type2 ON KEYS doc_type1.customer WHERE doc_type2._key=‘RESEARCHKEY’; I try to create an index: CREATE INDEX idx_profile ON bucket(doc_type1,doc_type…

Join query very slow

geraldss January 29, 2016, 3:40am 5

Please see my last answer in this thread:

Topic		Replies	Views
Slow index join SQL++ n1ql , index	6	1876	December 19, 2016
Perfomance issue with JOIN on same Bucket SQL++	4	969	October 25, 2017
Index with join SQL++ query , n1ql , index	14	3981	January 30, 2017
[bug] Query join between two types of documents (Adaptive index with predicate on document key) SQL++ n1ql	2	670	March 28, 2019
JOIN ON KEYS and Index scan timed out SQL++	5	1568	September 11, 2016