Specifies the database schema to use. This parameter only applies if you are using SQL Server for your IBM® Unica® Marketing Operations database.

Specifies the number of records beyond which a subquery should be used in the IN clause of SQL (for listing pages) instead of the actual entity IDs in the IN clause. Setting this parameter improves performance for IBM® Unica® Marketing Operations installations that have a lot of application data. As a best practice, do not change this value unless you encounter performance issues. If the parameter is missing or commented out, the database behaves as if the threshold was set to a very large value.

This parameter is used when configuring ALL IBM® Unica® Marketing Operations List Handlers. Use USE_DB_SORT_FOR_[MODULE]_LIST to override particular list's paging behavior.