# Dynamic filtering for highly-selective join optimization

DevFeed: [Dynamic filtering for highly-selective join optimization](<https://devfeed.tech/articles/dynamic-filtering-for-highly-selective-join-optimization-8625.md>)

Original publisher: [Read original article](<https://trino.io/blog/2019/06/30/dynamic-filtering.html>)

Author: Roman Zeyde

Published: 2019-06-30T00:00:00Z

Content type: article

Language: en

Sources: [Trino Blog](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [Optimization](<https://devfeed.tech/topics/optimization.md>)

Tags: [optimization](<https://devfeed.tech/tags/optimization.md>)

## AI overview

The article presents dynamic filtering through runtime predicate pushdown as an optimization for highly selective inner joins. It explains how collecting build-side values can prevent irrelevant probe-side rows from being read, improving join performance.

## Source excerpt

By using dynamic filtering via run-time predicate pushdown, we can significantly optimize highly-selective inner-joins.