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.

For best performance, you should create indexes on several of your Optimize tables. When creating per audience tables, for example the UA_ContactHistory tables, create these indexes on each table.

See the documentation for your database for the exact command to create an index. For example:

The following table gives the table names and the columns you should index. All of these tables exist in the Campaign system tables.

Table	Columns	Notes
audience_segMembership	Audience ID SegmentID	Using strategic segments is optional for Campaign flowcharts and Optimize sessions. If you are using strategic segments, you should have one segment membership table per audience level. You should create indexes on all segment membership tables. Each Audience ID column must match the corresponding Audience ID defined in Campaign.
UACO_PCTsessionID	OptimizeID ContactDateTime Audience ID ContactID TempOfferHistID OfferID	This table is automatically indexed when created by Optimize 7.5.2 or later version. If you are upgrading from a previous version of Optimize, you must index these tables manually. There is a UACO_PCTsessionID table for each Optimize session where session is the ACOSessionID. ACOSessionID is a unique identifier for each Optimize session defined in the UACO_OptSession table. Each Audience ID column must match the corresponding Audience ID defined in Campaign.
UACO_POAsessionID	OptimizeID TempOfferHistID	This table is automatically indexed when created by Optimize 7.5.2 or later version. If you are upgrading from a previous version of Optimize, you must index these tables manually. There is a UACO_POAsessionID table for each Optimize session where session is the ACOSessionID. ACOSessionID is a unique identifier for each Optimize session defined in the UACO_OptSession table.
UACO_RCsessionID	RandomIndex Audience ID	This table is automatically indexed when created by Optimize 7.5.2 or later version. If you are upgrading from a previous version of Optimize, you must index these tables manually. There is a UACO_RCsessionID table for each Optimize session where session is the ACOSessionID. ACOSessionID is a unique identifier for each Optimize session defined in the UACO_OptSession table. Each Audience ID column must match the corresponding Audience ID defined in Campaign.
audience_ContactHistory	PackageID Audience ID CellID ContactDateTime	The PackageID and CellID columns are already indexed in the sample UA_ContactHistory table created when you install Campaign. Each Audience ID column must match the corresponding Audience ID defined in Campaign.
audience_dtlContactHist	Audience ID ContactDateTime TreatmentInstID	Each Audience ID column must match the corresponding Audience ID defined in Campaign.