BookmarkSubscribeRSS Feed
SYN
Obsidian | Level 7 SYN
Obsidian | Level 7

What is the use of Hash tables in DI Studio? Can any body explain with example. Thank you.

Sreenivasa
2 REPLIES 2
RMP
SAS Employee RMP
SAS Employee

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.

shivas
Pyrite | Level 9

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to connect to databases in SAS Viya

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.

Discussion stats
  • 2 replies
  • 1327 views
  • 0 likes
  • 3 in conversation