Specifies Oracle hints to pass to Oracle from a SAS statement or SQL procedure.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Category: | Data Set Control |
| Default: | none |
| Data source: | Oracle |
Table of Contents
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= lets you specify an Oracle hint for SAS to pass as part of the SQL query.
libname mydblib oracle user=myusr1 password=mypwd1 path='myorapath';
proc print data=mydblib.payroll(orhints='/*+ ALL_ROWS */');
run;In this example, SAS
sends the Oracle hint '/*+ ALL_ROWS */' to
Oracle as part of this statement:
SELECT /*+ ALL_ROWS */ * FROM PAYROLL