Too many index spans generated for a query parameter that contains large number of elements

When a query uses an IN predicate with a query parameter, and the supplied value for the query parameter contains a large number of elements, we could generate a large number of index spans which is undesirable.

To repro, use the attachment of b1.sql in CBSE-14733.

With the repro we generate 110000 spans in 7.2.0 and earlier. With master due to previous fix for MB-51114 we don't generate that many spans, however the problematic code still exists.