A rule that finds all indexes that could implement one of the
FieldWithComparison
conjuncts of an AND filter
and produces a
RelationalGroupRefHolder
containing a plan that scans each of those indexes. These can then
be planned individually and then compared using the
PickFromPossibilitiesRule
.
Currently, this rule is pretty rough. Among other things, it does not have proper support for using the primary key
index and it pushes the entire filter into each of the members of the
FixedCollectionExpressionRef
, rather than removing the
comparison that is already planned. This rule will probably change substantially as the planner improves.