Problem Note 16732: Performance issues within SAS® Money Laundering Detection due to
incorrect indexes
Due to several incorrect indexes existing on tables, performance can
suffer dramatically within SAS Money Laundering Detection. Below is a
list of affected tables:
FSC_CASH_FLOW_FACT:
Remove: ALL indexes, except ACCOUNT_KEY and DATE_KEY
FSK_ALERT:
Add: Employee_ind
FSC_HOUSEHOLD_PARTY_BRIDGE:
Remove: eliminate UNIQUE constraint for HOUSEHOLD_PARTY_KEY index
FSC_PARTY_ACCOUNT_BRIDGE:
Update: the index order is incorrect and needs to be updated as
follows: ACCOUNT_KEY, PARTY_KEY, ROLE_KEY
FSC_BRANCH_DIM:
Add:
CREATE INDEX branch_type_desc ON MST_DIM.FSC_BRANCH_DIM
(
branch_type_desc
);
Indexes are not required for:
FSK_ALERT_ROUTING
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| SAS System | SAS Money Laundering Detection | Microsoft Windows NT Workstation | 1.4 | 1.4 | 9.1 TS1M3 SP3 | 9.1 TS1M3 SP3 |
| Microsoft Windows XP Professional | 1.4 | 1.4 | 9.1 TS1M3 SP3 | 9.1 TS1M3 SP3 |
| Microsoft Windows 2000 Server | 1.4 | 1.4 | 9.1 TS1M3 SP3 | 9.1 TS1M3 SP3 |
| Microsoft Windows Server 2003 Datacenter Edition | 1.4 | 1.4 | 9.1 TS1M3 SP3 | 9.1 TS1M3 SP3 |
| Microsoft Windows Server 2003 Enterprise Edition | 1.4 | 1.4 | 9.1 TS1M3 SP3 | 9.1 TS1M3 SP3 |
| Microsoft Windows Server 2003 Standard Edition | 1.4 | 1.4 | 9.1 TS1M3 SP3 | 9.1 TS1M3 SP3 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 1.4 | 1.4 | 9.1 TS1M3 SP3 | 9.1 TS1M3 SP3 |
| Microsoft Windows XP 64-bit Edition | 1.4 | 1.4 | 9.1 TS1M3 SP3 | 9.1 TS1M3 SP3 |
| Microsoft Windows 2000 Advanced Server | 1.4 | 1.4 | 9.1 TS1M3 SP3 | 9.1 TS1M3 SP3 |
| Microsoft Windows 2000 Datacenter Server | 1.4 | 1.4 | 9.1 TS1M3 SP3 | 9.1 TS1M3 SP3 |
| Microsoft Windows 2000 Professional | 1.4 | 1.4 | 9.1 TS1M3 SP3 | 9.1 TS1M3 SP3 |
*
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 |
| Topic: | System Administration ==> Servers
|
| Date Modified: | 2006-10-02 22:28:47 |
| Date Created: | 2005-12-22 16:39:47 |
