Temporary correlated hash table icon

Temporary Correlated Hash Table

The Temporary Correlated Hash Table icon indicates that a temporary correlated hash table was created in order to perform hash processing. A hash table is a data structure where the table data is collated based upon the value of a column or columns referred to as the hash key. The hash table can then be used to perform probe operation using the hash key to quickly retrieve all of the table data that matches a particular hash value. Because this is a correlated hash table, the hash table will need to be rebuilt prior to any scan or probe operations being performed.

Note: A correlated hash table is an internal data structure and can only be created by the system.