Designates which table is the larger table when you are processing a join that involves tables from two different types of databases.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Category: | Data Set Control |
| Alias: | DBMASTER= |
| Default: | none |
| Data source: | Amazon Redshift, Aster, DB2 under UNIX and PC Hosts, DB2 under z/OS, Google BigQuery, Greenplum, Hadoop, HAWQ, Impala, Informix, JDBC, Microsoft SQL Server, MySQL, Netezza, ODBC, OLE DB, Oracle, PostgreSQL, SAP ASE, SAP HANA, SAP IQ, Snowflake, Teradata, Vertica, Yellowbrick |
| Note: | Support for Yellowbrick was added in SAS 9.4M7. |
| See: | MULTI_DATASRC_OPT= LIBNAME option |
Table of Contents
designates which of two tables that are referenced in a join operation is the larger table.
You can use this option to specify which table reference in a join is the larger table. This can improve performance by eliminating the processing that is normally performed to determine this information. However, this option is ignored when outer joins are processed.
In this example, a table from an Oracle database and a table from a DB2 database are joined. DBLARGETABLE= is set to YES to indicate that the Oracle table is the larger table. The DB2 table is the smaller table.
libname mydblib oracle user=myusr1 /*database 1 */
pw=mypwd1 path='myorapath';
libname mydblib2 db2 user=myusr1 /*database 2 */
pw=mypwd1 path='mydb2path';
proc sql;
select * from mydblib.bigtab(dblargetable=yes), mydblib2.smalltab
where bigtab.x=smalltab.x;
quit;