Additional indexes for additional performance improvements
Beyond indexing the segment membership, contact history, and detailed contact history tables for each audience, and the PCT, POA, and RC tables for each session, there are other tables that you can index to improve the Contact Optimization session run performance.
The Contact Optimization installer indexes these tables properly. However, if you have issues with installation or upgrade, you might need to index these tables manually.
The specific tables and columns you need to index depends on your installation and configuration of IBM® Campaign and Contact Optimization, your specific data, and the specific optimization rules you are using. The following table lists tables and columns to index that improved performance in several instances.
audience_dtlContactHist
Each Audience ID column must match the corresponding Audience ID defined in Campaign.