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	2409	January 29, 2016
Couchbase Queries taking more time SQL++	1	616	April 23, 2021
Query for search including join on different bucket performing very slow SQL++ query , n1ql , couchbase-cli	9	850	July 15, 2022
Perfomance issue with JOIN on same Bucket SQL++	4	935	October 25, 2017
Query taking more than 40 sec to fecth result SQL++	1	631	March 5, 2019