During the Merge Records process, bind variables are used for all predicates. In some cases, when the cardinality of the column is low, DB2 does table scans when using indexes is more efficient. You can enable the Use Literals for Merge user property to direct the Merge Records process to generate literals in SQL statements for which the predicate is on a column known to have low cardinality. Add this user property to the business component on which Merge Records is run. For example, add Use Literals For Merge:S_BU and set its value to TRUE. During the Merge Records process, literals are used instead of bind variables in SQL statements whose predicates are on a column that is a foreign key to S_BU. You can inactivate this user property or modify its value. You can also create new instances of this user property. |