The LIBNAME Statement for Relational Databases DBLIBINIT= LIBNAME Option 89
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 may be able to use DBINDEX= to improve performance.
CAUTION:
Improper use of this option can degrade performance.
See “Using the DBINDEX=,
DBKEY=, and MULTI_DATASRC_OPT= Options” on page 38 for detailed
information about using this option.
See Also
To apply this option to an individual data set, see the data set option “DBINDEX=
Data Set Option” on page 175.
DBLIBINIT= LIBNAME Option
Specifies a user-defined initialization command to be executed once within the scope of the
LIBNAME statement or libref that established the first connection to the DBMS
Valid in:
the SAS/ACCESS LIBNAME statement
DBMS support: DB2 OS/390, DB2 UNIX/PC, Informix, ODBC, OLE DB, Oracle,
Microsoft SQL Server, SYBASE, Teradata
Default value: none
Syntax
DBLIBINIT= <’>DBMS-user-command<’>
Syntax Description
DBMS-user-command
