So far we have covered query execution stages , statistics , sequential and index scan , and have moved on to joins. The previous article focused on the nested loop join , and in this one I will explain the hash join . I will also briefly mention group-bys and distincs.