Hi, @vsr1 this query is taking more than 1 second, even though we have an index as suggested by CB, can you help with this ? WITH instances AS ( SELECT instance.pageId, * FROM bucketName AS instance WHERE instance.type = ‘instance’ AND instance.clientId = “12345” AND instance.id IN [“1213”,“…

Join Query Taking time

vsr1 May 17, 2021, 3:38pm 2

Topic		Replies	Views
Join query very slow SQL++	4	2396	January 29, 2016
Couchbase Queries taking more time SQL++	1	609	April 23, 2021
Query for search including join on different bucket performing very slow SQL++ query , n1ql , couchbase-cli	9	825	July 15, 2022
Perfomance issue with JOIN on same Bucket SQL++	4	919	October 25, 2017
N1QL \| Query Performance Issue with multiple where clause SQL++ query , index	6	871	April 21, 2021