N1QL query performance with several JOINs


I want to query data that does not change very often and that is split into several documents, i.e. I want to JOIN multiple documents for a query. Is the performance of querying a JOIN of multiple documents comparable to querying a single document that contains all the information? In other words, does creating new merged documents, each containing the information of several smaller documents in order to avoid the JOINs, improve query performance considerably?

1 Like