Problem Note 15943: Installation of HOTFIX 82BC08 can cause performance degradation by not
using available index
The installation of HOTFIX 82BC08 can introduce performance degradation
by not using available index(es).
The use of column aliases on an indexed column(s) can prevent the SQL
optimizer from recognizing a possible indexed join strategy.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| SAS System | Base SAS | OpenVMS VAX | 8.2 TSM1 | 8.2 TSM1 |
| Solaris | 8.2 TSM1 | 8.2 TSM1 |
| 64-bit Enabled Solaris | 8.2 TSM1 | 8.2 TSM1 |
| z/OS | 8.2 TSM1 | 8.2 TSM1 |
| ABI+ for Intel Architecture | 8.2 TSM1 | 8.2 TSM1 |
| Linux | 8.2 TSM1 | 8.2 TSM1 |
| HP-UX | 8.2 TSM1 | 8.2 TSM1 |
| 64-bit Enabled HP-UX | 8.2 TSM1 | 8.2 TSM1 |
| CMS | 8.2 TSM1 | 8.2 |
| IRIX | 8.2 TSM1 | 8.2 TSM1 |
| OpenVMS Alpha | 8.2 TSM1 | 8.2 TSM1 |
| Tru64 UNIX | 8.2 TSM1 | 8.2 TSM1 |
*
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: | SAS Reference ==> Procedures ==> SQL SAS Reference ==> SQL
|
| Date Modified: | 2005-08-24 13:37:24 |
| Date Created: | 2005-08-15 16:09:48 |