Performance Enhancement | SQL Engine 17.10 | Teradata Vantage - 17.10 - Performance Enhancement - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Advanced SQL Engine Release Summary

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Release Notes
Publication ID
English (United States)

Bloom Filter optimization is added to classical hash join algorithms for Release 17.10. A Bloom Filter is a compact metadata structure on the join column of one relation of a hash join step. The Bloom Filter is used while reading the other relation of the join as an existence check or test. Specifically, the build side of a classical hash join produces a bitmap spool based on the join column while building the hash table. This bitmap spool is passed down to the probe side of the join to be able to filter rows while the probe side is being read.


This feature can improve the performance of some joins.


Bloom Filter is enabled by default.