I have the query: SELECT VALUE {'en': col_doc.data.en, 'lang': IFMISSING(col_doc.data.en, col_doc.data.en), 'doc_id': col_doc.id, 'game_count': ( SELECT VALUE COUNT(*) FROM deploy_dev.game.rollingslots col_doc_game JOIN deploy_dev.providers_game.rollingslots col_doc_prov ON col_doc_prov…

Hi @Lenty_Me , Currently array indexes do not support prefix search. That means a composite array index will be used only when all the indexed fields are specified in the predicate. For your case, the composite array index is on the two fields alias from the array field data.en.categories and data.…

Dual index in analytics not working

Analytics

Lenty_Me July 12, 2023, 6:43am 5

Thank you very much. It works perfect

Topic		Replies	Views
How Using Analytics Indexes in JOIN Analytics query , n1ql , analytics	3	962	December 13, 2022
Query analyzer doesn't use index specified by "use index" statement SQL++	7	1381	June 12, 2021
Composite index not used by query SQL++ query , n1ql , index , array-query	2	1280	October 24, 2019
Analytics Index with IN Analytics	1	892	June 17, 2022
Compound analytics index usage on joins Analytics query , index	2	413	January 22, 2024

Dual index in analytics not working

Related topics