Data Set Options for Relational Databases |
Specifies Oracle hints to pass to Oracle from a SAS statement
or SQL procedure.
Default value: |
none
|
Valid in: |
DATA and PROC steps (when accessing DBMS data
using SAS/ACCESS software)
|
DBMS support: |
Oracle
|
-
Oracle-hint
-
specifies an Oracle hint for SAS/ACCESS to
pass to the DBMS as part of an SQL query.
If you specify an Oracle hint, SAS passes
the hint to Oracle. If you omit ORHINTS=, SAS does not send any hints to Oracle.
This example runs a SAS procedure on DBMS data and SAS
converts the procedure to one or more SQL queries. ORHINTS= enables you to
specify an Oracle hint for SAS to pass as part of the SQL query.
libname mydblib oracle user=testuser password=testpass path='myorapath';
proc print data=mydblib.payroll(orhints='/*+ ALL_ROWS */');
run;
In the next example, SAS sends the Oracle hint '/*+ ALL_ROWS */'
to Oracle as part of this statement:
SELECT /*+ ALL_ROWS */ * FROM PAYROLL
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.