What is the use of Hash tables in DI Studio? Can any body explain with example. Thank you.
Hash tables are used in the Lookup transformation where lookups are performed against data in memory. This can have a significant impact on performance. Maybe you could be more specific with your question.
Hi,
See the definition from SAS DI documentation.
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, which is not presented here, determines whether
a hash join is chosen.
Thanks,
Shiva
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.