Indexing Contact Optimization tables

Create indexes on several of your Contact Optimization tables to improve performance.

Note: 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.

When you create the tables that are required for each audience level, 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:

CREATE INDEX IndexName ON TableName ( ColumnName )

The following table gives the table names and the columns to index. All of these tables exist in the Campaign system tables. In addition to the following existing indexes, you can add extra indexes on the Campaign system tables to improve run time performance of a Contact Optimization session run. For more information about extra indexes, see the IBM® Contact Optimization Troubleshooting and Tuning Guide.

Table 1. Contact Optimization tables to index
A three-column table that lists the table, column names, and details about tables to index to improve Contact Optimization performance.
Table	Columns	More information
`audience_segMembership`	`Audience ID` `SegmentID`	Using strategic segments is optional for Campaign flowcharts and Contact Optimization sessions. If you are using strategic segments, have one segment membership table per audience level. 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 Contact Optimization, you must index these tables manually. There is a `UACO_PCTsessionID` table for each Contact Optimization session where `session` is the `ACOSessionID`. `ACOSessionID` is a unique identifier for each Contact Optimization session that is 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 Contact Optimization, you must index these tables manually. There is a `UACO_POAsessionID` table for each Contact Optimization session where `session` is the `ACOSessionID`. `ACOSessionID` is a unique identifier for each Contact Optimization session that is 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 Contact Optimization, you must index these tables manually. There is a `UACO_RCsessionID` table for each Contact Optimization session where `session` is the `ACOSessionID`. `ACOSessionID` is a unique identifier for each Contact Optimization session that is 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 that is 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.