docs - update optimizer_array_expansion_threshold default to 100
in the query predicate contains more than the number elements specified by parameter, GPORCA
disables the transformation of the predicate into its disjunctive normal form during query
optimization. </p>
- <p>The default value is 25. </p>
+ <p>The default value is 100. </p>
<p>For example, when GPORCA is executing a query that contains an <codeph>IN</codeph> clause
- with more than 25 elements, GPORCA does not transform the predicate into its disjunctive
+ with more than 100 elements, GPORCA does not transform the predicate into its disjunctive
normal form during query optimization to reduce optimization time consume less memory. The
difference in query processing can be seen in the filter condition for the
<codeph>IN</codeph> clause of the query <codeph>EXPLAIN</codeph> plan.</p>
