Details
-
Technical task
-
Resolution: Fixed
-
Major
-
None
-
None
-
None
-
None
-
DOC-2022-S14, DOC-2022-S15
Description
Pls add this detail about 8K to the IN/WITHIN documentation.
https://developer.couchbase.com/documentation/server/4.5/n1ql/n1ql-language-reference/collectionops.html
thanks,
-Prasad
Hi Ketaki,
IN is perfect for this. Up to 8192 values currently.
Gerald
From: Ketaki Gangal <Ketaki@couchbase.com>
Date: Monday, January 16, 2017 at 10:40 AM
To: Query <query@couchbase.com>
Subject: Question about larger number of 'IN' values
Hello Query team,
A customer is interested in having say 200 ( dynamic values, i.e. they don’t know these values ahead of time) in the IN clause of a query.
Question
Is something like ‘select a,b,c from table where a in [val1, val2, … , val200] efficient from a query perspective?
Can we do something more suitable for this use-case, i.e. replace IN with any other approach.
thanks!
Ketaki