Problem Note 30564: Poor SAS® Campaign Studio OR node performance occurs against DB2
 |  |  |  |  |
SAS® Marketing Automation 4.4 generates different SQL code than does the SAS Marketing Automation 4.3 when using the OR node in diagrams.
When the meets any conditions defined by input nodes type is chosen in an OR node, the underlying SQL statement uses a UNION/IN statement instead of an OR statement (SAS Marketing Automation 4.3 uses an OR statement).
The union queries are performing poorly in DB2 compared to using the OR method. When this happens, queries can to take up to three times longer to execute.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Campaign Studio | Microsoft® Windows® for x64 | 4.4 | 5.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft Windows 2000 Advanced Server | 4.4 | 5.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Datacenter Server | 4.4 | 5.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Server | 4.4 | 5.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Professional | 4.4 | 5.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows NT Workstation | 4.4 | 5.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 4.4 | 5.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.4 | 5.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.4 | 5.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows XP Professional | 4.4 | 5.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Windows Vista | 4.4 | 5.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
A fix for this issue for SAS Marketing Automation 4.4 is available at:
http://www.sas.com/techsup/download/hotfix/ma44.html#030564| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2007-11-15 13:28:59 |
| Date Created: | 2007-11-15 08:53:08 |