Hi, I am a little bit perplex about the execution time of queries like SELECT META(myBucket).id FROM myBucket WHERE META(myBucket).id LIKE “prefix:%”… The execution time of this query is exploding the more documents there are in the bucket, like it was doing a full scan of the bucket instead of us…

Explanation on Primary Scan / Secondary Scan

lbertrand December 9, 2015, 9:59pm 11

Thank you.
I saw 4.1 is now GA so will try.

But going through running many times these tests I encountered something new regarding index compaction. See Index Fragmentation

Laurent.

Topic		Replies	Views
How to quickly list 1M document identifiers? SQL++	3	2688	June 22, 2022
Initial index performance SQL++ query , n1ql , index	10	2085	May 8, 2017
CB 6.0.0 community with 30+ Million objects - SELECT takes too long to execute SQL++ query , java , n1ql , server , index	1	892	August 18, 2020
Search by using the prefix of the ID SQL++	11	3921	September 4, 2019
Performance Basic Query Update Couchbase Server	12	2273	September 13, 2019