DBINDEX= LIBNAME Option

Improves performance when processing a join that involves a large DBMS table and a small SAS data set.

Valid in:	SAS/ACCESS LIBNAME statement
Default:	DBMS-specific
Restriction:	Oracle: Use this option only when the object is a TABLE, not a VIEW. Use DBKEY= when you do not know whether the object is a TABLE.
Data source:	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
See:	DBINDEX= data set option, Using the DBINDEX=, DBKEY=, and MULTI_DATASRC_OPT= Options

Syntax

Details

Syntax

DBINDEX=YES | NO

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 process 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.