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:
create unique index library.T1800000000TABLENAME on
library.T1800000000TABLENAME ( SUBJECT_ID ) PARALLEL 5);
Operating System and Release Information
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 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2016-09-22 09:58:05 |
Date Created: | 2016-09-20 14:50:08 |