Provides information on any temporary has tables that were used. Hash join and hash group may be chosen by the optimizer to perform an SQL statement because it will result in the best performance. However, hashing can use a significant amount of temporary storage. If the hash tables are very large, and several users are performing hash joins or group by at the same time, the total resources necessary for the hash tables may become a problem.