Skip to Main Content
SAS Data Integration Studio 4.9
book

SAS Data Integration Studio 4.9

by SAS Documentation
August 2014
Intermediate to advanced content levelIntermediate to advanced
808 pages
25h 30m
English
SAS Institute
Content preview from SAS Data Integration Studio 4.9
The larger table has an index that includes all the join keys.
Encourage an index nested loop with IDXWHERE=YES as a data set option, as follows:
proc sql _method; select ... from smalltable,
largetable(idxwhere=yes). You can also turn on the Suggest Index Join
property on the properties panes for the tables in the query.
Hash Joins
The optimizer considers a hash join when an index join is eliminated as a possibility.
With a hash join, the smaller table is reconfigured in memory as a hash table. SQL
sequentially scans the larger table and performs row-by-row hash lookup against the
small table to form the result set. A memory-sizing formula, ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

A Gentle Introduction to Statistics Using SAS Studio in the Cloud

A Gentle Introduction to Statistics Using SAS Studio in the Cloud

Ron Cody

Publisher Resources

ISBN: 9781629593098