Indexing Contact Optimization tables
Create indexes on several of your Contact Optimization tables to improve 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.
When you create the tables 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.
Contact Optimization tables to index
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.
Copyright IBM Corporation 2013. All Rights Reserved.