Hello,

Question. regarding Nested loop versus Hash join. I read couple of article about this. What they are saying is, Nested loop joins are useful when small subsets of data are being joined and if the join condition is an efficient way of accessing the second table. My question is what is small subset of data? How can we quantify Small subset of data
?


Another question regardsing hash join. Hash joins are used for joining large data sets. What is large data sets?? How can we quantify large data sets??

I would appreciate if any one can answer for my questions. Thanks