Database tuning
Add appropriate indexes in Profile, Offer suppression, and Score override tables.
Profile tables. Create a unique index on the audience level fields.
Offer suppression tables. Create an index on the audience level fields.
Score override tables. Create an index on the audience level fields.
Also, make sure that the statistics on these indexes are up to date. For example, if the Audience ID is a combination of two columns
CustomerId
and
HouseholdId
, create an index on these columns in all the tables and update the statistics.
Copyright IBM Corporation 2013. All Rights Reserved.