Indexing Contact Optimization tables
Create indexes on several of your Contact Optimization tables to improve performance.
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 HCL® Contact Optimization Troubleshooting and Tuning Guide.
Table | Columns | More information |
---|---|---|
audience_segMembership |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
Each Audience ID column must match the corresponding Audience ID defined in Campaign. |