Indexing Unica Optimize tables

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

Note: The Unica Optimize 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 Unica Campaign system tables. In addition to the following existing indexes, you can add extra indexes on the Unica Campaign system tables to improve run time performance of a Unica Optimize session run. For more information about extra indexes, see the IBM® Optimize Troubleshooting and Tuning Guide.

Table 1. Unica Optimize tables to index
A three-column table that lists the table, column names, and details about tables to index to improve Unica Optimize performance.
Table	Columns	More information
`audience_segMembership`	`Audience ID` `SegmentID`	Using strategic segments is optional for Unica Campaign flowcharts and Unica 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 Unica 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 Unica Optimize, you must index these tables manually. There is a `UACO_PCTsessionID` table for each Unica Optimize session where `session` is the `ACOSessionID`. `ACOSessionID` is a unique identifier for each Unica Optimize session that is defined in the `UACO_OptSession` table. Each `Audience ID` column must match the corresponding `Audience ID` defined in Unica 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 Unica Optimize, you must index these tables manually. There is a `UACO_POAsessionID` table for each Unica Optimize session where `session` is the `ACOSessionID`. `ACOSessionID` is a unique identifier for each Unica Optimize 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 Unica Optimize, you must index these tables manually. There is a `UACO_RCsessionID` table for each Unica Optimize session where `session` is the `ACOSessionID`. `ACOSessionID` is a unique identifier for each Unica Optimize session that is defined in the `UACO_OptSession` table. Each `Audience ID` column must match the corresponding `Audience ID` defined in Unica 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 Unica Campaign. Each `Audience ID` column must match the corresponding `Audience ID` defined in Unica Campaign.
`audience_dtlContactHist`	`Audience ID` `ContactDateTime` `TreatmentInstID`	Each `Audience ID` column must match the corresponding `Audience ID` defined in Unica Campaign.