DBINDEX= LIBNAME Statement Option
Improves performance when processing a join that
involves a large DBMS table and a small SAS data set.
| Valid in: |
LIBNAME statement |
| Default: |
DBMS-specific |
| Supports: |
DB2 UNIX/PC, Greenplum, MySQL, ODBC, Oracle, Teradata |
Syntax
Syntax Description
- YES
-
specifies that SAS
uses columns in the WHERE clause that have defined DBMS indexes.
- NO
-
specifies that SAS
does not use indexes that are defined on DBMS columns.
Details
When you are processing
a join that involves a large DBMS table and a relatively small SAS
data set, you might be able to use DBINDEX= to improve performance.
CAUTION:
Improper
use of this option can degrade performance.
See Also
To apply this
option to an individual table, use the DBINDEX= data set option.