You can configure the maximum size of any candidate list IN clause
created by the pipeline during entity resolution.
Procedure:
- In the Configuration Console, click the Setup button.
- Click the General button.
- Click the System Parameters tab.
- From the Parameter Group drop-down list, select
the DB_CONFIG parameter group.
- Click the MAX_IN_CLAUSE system parameter.
- In the Current Value field, type the maximum
number of characters that you want to include in an IN clause when generating
a candidate list as part of the entity resolution process. Valid values are
any integer from 0 to 1000. To return this system parameter to
its default value, type the value that is displayed in the Default
Value field, in this field.
Note: This value
affects the performance of your database. Based on the size of your database
and the capabilities of your system hardware, carefully consider the value
you specify for this parameter.
- Click Save.