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 you can index to improve the Optimize session run performance. The Optimize installer should index these tables properly. However, if you have issues with installation or upgrade, you may need to index these tables manually.

The specific tables and columns you need to index depends on your installation and configuration of IBM® UnicaCampaign and Optimize, your specific data, and the specific optmization rules you are using. The following table lists tables and columns to index that have improved performance in several instances.

Table	Columns	Notes
audience_dtlContactHist	Audience ID ContactDateTime TreatmentInstID ContactStatusID	Each Audience ID column must match the corresponding Audience ID defined in Campaign.
UA_Treatment	OfferID TreatmentInstID HasDetailHistory PackageID CellID OfferHistoryID	You should also allow reverse scans on these indexes.
UA_OfferAttribute	AttributeID	You should also allow reverse scans on these indexes.
UA_Offer	OfferTemplateID	You should also allow reverse scans on these indexes.
UA_OfferTemplAttr	OfferTemplateID	You should also allow reverse scans on these indexes.