DEFAULT_MAX_ITEMS_IN_SQL_VALUE

Description:

This parameter sets the maximum number of allowed elements within a single SQL IN clause. If the number of elements is greater than the number specified in this parameter, the SQL IN clause is broken into multiple portions with each portion limited to only as many elements as specified in this parameter.

Note: For this registry parameter to function properly, DBIntetface.FitQueryToMaxSQLExpressionlimit() is assumed to be used. For more information, see Javadoc.

Valid Values:

any whole number

Default Value:

1000

Location:

system/modules/scheduleOptimization

Effective:

n/a