Distinct hash table probe icon

Distinct Hash Table Probe

The Distinct Hash Table Probe icon indicates that the selection criteria that match the key columns used to create the temporary distinct hash table will be probed to find all of the matching values stored within the hash table. The use of a distinct hash table probe will allow the optimizer to generate a plan that can take advantage of any non-join selection while creating the temporary distinct hash table. An additional benefit of using a distinct hash table probe is that the data structure of the temporary distinct hash table will usually cause the table data to remain resident within main memory after creation thus reducing paging on the subsequent probe operation.

Also referred to as: Distinct Hash Table Probe, Preload; Distinct Hash Table Probe Distinct; Distinct Hash Table Probe Distinct, Preload