Attribute

InValuesLimit (ivl)

Purpose

Maximum number of values that IN clause sub-query can have to be materialized.

Behavior

This session option limits the number of constant values that an IN clause can contain to process it as IN subquery.

If the number of constant values exceeds this limit then it is processed as join.

Default Value

200