topic What is the use of Hash tables in DI Studio in SAS Data Management

What is the use of Hash tables in DI Studio

SYN — Fri, 11 May 2012 05:03:52 GMT

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

Re: What is the use of Hash tables in DI Studio

RMP — Fri, 11 May 2012 13:24:15 GMT

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.

Re: What is the use of Hash tables in DI Studio

shivas — Fri, 11 May 2012 15:09:20 GMT

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