To Hash or Not To Hash! That is the Question!! When it Comes to SQL!!!

This paper demonstrates how to compare the efficiency of using the hash object when the same results can be produced with PROC SQL. In the process of efficiency quantification, other efficiency determinants such as data set size, compression, index, and environmental factors (remote PC versus local laptop) are accounted for in an experimental model with a simulation approach.