IM Relationship Resolution Information Center, Version 4.2

Configuring system parameters for the database

You can configure the maximum size of any candidate list IN clause created by the pipeline during entity resolution.

Procedure:
  1. In the Configuration Console, click the Setup button.
  2. Click the General button.
  3. Click the System Parameters tab.
  4. From the Parameter Group drop-down list, select the DB_CONFIG parameter group.
  5. Click the MAX_IN_CLAUSE system parameter.
  6. 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.
  7. Click Save.


Feedback

Last updated: 2009