Description
filter condition is depends on multiple unnests
CREATE INDEX ix22 ON default( (ALL ARRAY (ALL ARRAY [op.name,op.val,x] FOR op IN x END) FOR x IN a1 END )); |
|
EXPLAIN SELECT [op.name,op.val,x]
|
FROM default AS d UNNEST d.a1 AS x |
UNNEST x AS op
|
WHERE [op.name,op.val,x] = ["type2", "bla","xxx"] ; |
|
Above query is not using the index mentioned above.