Problem Note 59016: Performance problems occur when SAS® Customer Intelligence builds indexes on uploaded MATABLES tables
 |  |  |  |  |
To enhance performance, SAS® Customer Intelligence builds and uploads the MATABLES data sets to the database in order to enable in-database joins.
The mausrupl.sas macro is available to enable the CREATE TABLE syntax that is used in this upload to be tuned to meet your specific requirements. The CREATE INDEX command is not available in this macro. Therefore, it cannot be tuned, and performance optimization options (for example, Oracle's PARALLEL option)cannot be added to the CREATE UNIQUE INDEX command. As a result, you might experience performance issues when indexes are built on uploaded MATABLES.
Click the Hot Fix tab in this note to access the hot fix for this issue.
This hot fix includes the ability to change the CREATE INDEX syntax to meet your specific tuning requirements. The following CREATE UNIQUE INDEX statement is an example of how you can tune the statement:
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Customer Intelligence Core Mid-Tier | Microsoft® Windows® for x64 | 6.4 | 9.4 TS1M2 | ||
| 64-bit Enabled AIX | 6.4 | 9.4 TS1M2 | ||||
| 64-bit Enabled Solaris | 6.4 | 9.4 TS1M2 | ||||
| HP-UX IPF | 6.4 | 9.4 TS1M2 | ||||
| Linux for x64 | 6.4 | 9.4 TS1M2 | ||||
| Solaris for x64 | 6.4 | 9.4 TS1M2 | ||||
A fix for this issue for SAS Marketing Automation 6.5 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Z77.html#59016A fix for this issue for SAS Marketing Automation 6.4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/U53.html#59016| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2016-09-22 09:58:05 |
| Date Created: | 2016-09-20 14:50:08 |