Problem Note 19344: SAS® may ignore indexes during query on 64-Bit UNIX systems
If a data set created prior to SAS 9.2 has more than two gigabytes of
rows, SAS does not use indexes in a query even if an appropriate index
exists and its use is warranted. This includes DATA Step and SQL
queries.
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 | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.2 TS1M0 |
| HP-UX IPF | 9.1 TS1M3 | 9.2 TS1M0 |
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.2 TS1M0 |
| Linux on Itanium | 9.1 TS1M3 | 9.2 TS1M0 |
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.2 TS1M0 |
| Tru64 UNIX | 9.1 TS1M3 | 9.2 TS1M0 |
*
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: | Data Management ==> Access ==> SAS I/O
|
| Date Modified: | 2007-05-22 14:02:46 |
| Date Created: | 2007-01-15 15:57:35 |
