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	1840	December 19, 2016
Perfomance issue with JOIN on same Bucket SQL++	4	945	October 25, 2017
Join Query Taking time SQL++	1	623	May 17, 2021
Count(*) is super slow, and index across multiple document types is not fast enough SQL++	4	660	February 12, 2021
Query with join very slow SQL++ query , n1ql	11	2834	January 12, 2017