Temporary distinct hash table icon

Temporary Distinct Hash Table

The Temporary Distinct Hash Table icon indicates that a temporary distinct hash table was created in order to perform hash processing. A distinct hash table is a data structure identical to the temporary hash table except all duplicate data will be compressed out of the temporary being created. The resulting hash table can then be used to perform distinct or aggregate operations for the query.

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