The LIBNAME Statement for Relational Databases |
Improves
performance when processing a join that involves a large
DBMS table and a small SAS data set.
Default value: |
DBMS-specific
|
Valid in: |
SAS/ACCESS LIBNAME
statement
|
DBMS support: |
Aster nCluster, DB2 under
UNIX and PC Hosts, Greenplum, HP Neoview, Informix, Microsoft SQL Server,
MySQL, Netezza, ODBC, OLE DB, Oracle, Sybase, Sybase IQ, Teradata
|
-
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.
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.
![[cautionend]](../../../../common/63294/HTML/default/images/cautend.gif)
To apply this option to an individual data set, see
the DBINDEX= Data Set Option.
For detailed information about using this option, see
Using the DBINDEX=, DBKEY=, and MULTI_DATASRC_OPT= Options.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.