Indexing Optimize tables

Create indexes on several of your Optimize tables to improve performance.

The Optimize installer indexes these tables properly. However, if you have issues with installation or upgrade, you might need to index these tables manually.

When creating 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.

Optimize tables to index

Table

Columns

More Information

audience_segMembership

Audience ID

SegmentID

Using strategic segments is optional for Campaign flowcharts and Optimize 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 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

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.