You should create indices on the tables you create. For example, if you create the INDIV_ContactHistory table for a new Individual audience level, you could create an index as follows: CREATE INDEX XIE1INDIV_ContactHistory ON INDIV_ContactHistory ( IndivID ).The SQL statements used to create the Campaign default audience level tables and their related indices can be used as templates to create tables for other audience levels. For example, you could use UA_ContactHistory as a template for Acct_ContactHistory (for an audience level Account). To see the SQL statements, look in the /Campaign/ddl directory for the script that creates system tables for your database management system.
Unica Campaign
8.5.0
|
Copyright IBM Corporation 2011. All Rights Reserved.
|
For more information, see our support and community site: Customer Central
|
|