42790 - Query in plan import results in poor performance

Problem Note 42790: Query in plan import results in poor performance

A query in Oracle takes a long time to execute in SAS^® Pack Optimization.

The long run time occurs when both of the following conditions are true:

There are no warning or error messages.

A fix for this issue is planned for a future software release.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
Product Family	Product	System	Reported	Fixed*	Reported	Fixed*
SAS System	SAS Pack Optimization	Microsoft Windows Server 2008	2.2_M1	3.2	9.2 TS2M3	9.3 TS1M1
		64-bit Enabled AIX	2.2_M1	3.2	9.2 TS2M3	9.3 TS1M1
		Microsoft Windows Server 2003 Standard Edition	2.2_M1	3.2	9.2 TS2M3	9.3 TS1M1
		Microsoft Windows Server 2003 Enterprise Edition	2.2_M1	3.2	9.2 TS2M3	9.3 TS1M1
		Microsoft Windows Server 2003 Datacenter Edition	2.2_M1	3.2	9.2 TS2M3	9.3 TS1M1
		Microsoft Windows Server 2003 for x64	2.2_M1	3.2	9.2 TS2M3	9.3 TS1M1
		Microsoft Windows Server 2008 for x64	2.2_M1	3.2	9.2 TS2M3	9.3 TS1M1

* 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.

A fix for this issue for SAS Merchandise Intelligence 4.2_M2 is available at:

Type:	Problem Note
Priority:	alert

Date Modified:	2012-11-14 11:16:57
Date Created:	2011-03-28 09:35:05