I have a expression in a where clause that looks like: and ARRAY_LENGTH(ARRAY_INTERSECT([“900”,“400”], r3.groupTags)) > 0 r3 is an unnested item from an array of objects is there a way to get an index to hit on that expression or something equivalent?

Is it possible to post sample document and query. This is equivalent of . ANY v IN r3.groupTags SATISIFIES v IN ["900","400"] END If groupTags is part of document you can create ARRAY Index

Thank you! That did it. It was tricky because it was also nested. Here is the new index: Create Index idx_gt on app (Distinct Array (Distinct Array gt for gt in r.groupTags END) FOR r in ruleVersions.__main__ end) where type = "rule" Here is the query that uses it. The stuff is b…

Hope your question is answered.

It was thanks. That was the hint I needed

Any tips on how to modify the index to make it a covering index?

Include ruleVersions.__main__ as trailing key

That worked. cut execution time in half. Thanks! Question: How does one know how to order the key parts in a index definition? Is there a write up on that somewhere?

@DrGarbinsky , The following might be useful for you based on above query. While doing MIN/MAX you can project what ever you want. Example: MAX( [ maxRule.version, maxRule] )[1] AS theRule Max argument is ARRAY of First element is expression on what you want to do MAX …

Index for the intersection of a sub array and a static array as a parameter

SQL++

vsr1 September 22, 2017, 5:18pm 9

Indexer uses B-tree .Check this out N1ql indexing sequence

Useful N1QL articles

Topic		Replies	Views
Index specific items inside an array not working SQL++	6	912	February 14, 2019
Create a covering index for two array sub-items SQL++ index	1	700	January 25, 2022
Array index not being used by query SQL++ query , n1ql , index	6	2533	January 11, 2018
Array index with multiple ALL expressions? SQL++ index	1	1681	May 28, 2018
Covering index for nested array SQL++ index	10	2456	June 15, 2019

Index for the intersection of a sub array and a static array as a parameter

Related topics