Hi, We are trying to retrieve data from about couple of million documents which has complicated structure of nested data. For example the document looks as below OuterData { id : outerID records: [ { parameters: { param1:val1, param2:val2 }, baseAmount : [ { amount : $ 5, validity : …

N1QL Union performance with UNNEST

vsr1 August 8, 2017, 7:04am 6

Are you projecting values from rec or amount

Topic		Replies	Views
Unable to UNNEST when combining with USE KEYS SQL++ query , n1ql	6	1330	May 22, 2020
UNION between two types of documents, and join information on one of them SQL++ query , n1ql	4	3288	September 27, 2016
Noobie question regarding query SQL++	1	660	November 12, 2018
Unnest not used in query slows performance Couchbase Server query	1	452	May 17, 2021
N1QL combining array in result like in-line view SQL++	5	4281	November 2, 2017