SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 19344: SAS® may ignore indexes during query on 64-Bit UNIX systems

DetailsHotfixAboutRate It

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

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemBase SASMicrosoft® Windows® for 64-Bit Itanium-based Systems9.1 TS1M39.2 TS1M0
HP-UX IPF9.1 TS1M39.2 TS1M0
64-bit Enabled Solaris9.1 TS1M39.2 TS1M0
Linux on Itanium9.1 TS1M39.2 TS1M0
64-bit Enabled AIX9.1 TS1M39.2 TS1M0
Tru64 UNIX9.1 TS1M39.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.