Composite index not used by query

SQL++
, , ,
2

Duw to OR it can’t use because index doesn’t maintain when leading index key is missing in the document. Every OR term must have OR index.

Option 1: Create another index

  CREATE INDEX  `idx_2`  ON  `spots`
(  DISTINCT ARRAY r FOR r IN  `conv_recipients`  END)
WHERE ( `type`  = “conversation”)

Option 2: if you are looking both same value

    CREATE INDEX idx_3 ON spots( DISTINCT ARRAY r FOR r IN ARRAY_APPEND(conv_recipients,conv_owner_id)  END)
WHERE (type = “conversation”)

SELECT *
FROM  `spots`
WHERE type = ‘conversation’
AND ANY r IN  ARRAY_APPEND(`conv_recipients`, `conv_owner_id` )  SATISFIES r=6 END