Problem Note 9955: WHERE clause may not be passed to Rdb database for processing, causing
poor performance
When running queries against Oracle/Rdb tables via SAS/Access views in
SAS 8.2, you may encounter very slow performance compared to previous
releases of SAS.
Unless WHERE clause variables are in uppercase characters, the WHERE
clause is not passed to the database for processing. If this happens,
all records in the table defined by the SAS/Access view will be read
and WHERE processing will occur on the SAS side. Because all records
are read, and because existing Oracle/Rdb table indices cannot be used
in this case, processing time could increase dramatically.
The workaround is to change all variables in your WHERE clause to
uppercase characters so that the WHERE clause will be passed to the
database for processing.
A Technical Support hot fix for Release 8.2 (TS2M0) for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#009955
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to Oracle Rdb | OpenVMS Alpha | 8.2 TS2M0 | 8.2 TS2M0 |
*
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 ==> ACCESS
|
| Date Modified: | 2003-08-06 11:08:07 |
| Date Created: | 2003-05-01 15:21:31 |