In this article, I will show you how to keep small tables in memory using your customized hash map to optimize performance for certain workloads.

I have used this method myself in a cursor of a stored procedure to minimize the runtime of several thousand requests against small tables by a factor of 100: 

Sparse Maps

Best Regards,

Roland - DWHPro