Hi all, I have created the following index for a N1QL query: CREATE INDEX index_write_userrelation_relationkeys ON write (relationKeys) WHERE docType = 'userRelation' USING GSI The n1ql query is: SELECT relationKeys FROM write WHERE docType = 'userRelation' AND ANY relationKey in relationKeys …

Creating an index for a query that uses LOWER

vsr1 August 3, 2017, 1:07pm 6

Covered index should work in your case

1 Like