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 under UNIX and PC, Greenplum, MySQL, ODBC, Oracle, Teradata
Syntax
Syntax Description
Details
See Also

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 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.
Note: Improper use of this option can degrade performance.

See Also

To apply this option to an individual table, use the DBINDEX= data set option.
Copyright © SAS Institute Inc. All Rights Reserved.