Sorry for the late reply. I tried this query too, but no much difference in query execution time. As discussed before I think since we have large amount of data, its taking some time. Thanks for the response
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| I have a problem with ARRAY INDEXES | 24 | 2971 | September 29, 2016 | |
| Distinct values across large number of documents | 7 | 1228 | February 10, 2021 | |
| Create Secondary Index on Array | 14 | 2891 | October 27, 2017 | |
| How to aggregate an array with ARRAY_AGG and get performance | 15 | 2968 | June 28, 2019 | |
| N1Ql with cover index performance very slow | 41 | 4352 | October 21, 2016 |