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

A fix for this issue for SAS Money Laundering Detection 1.4 is available at: