yohei-a https://blog.hatena.ne.jp/yohei-a/ ablog https://yohei-a.hatenablog.jp/ AWS Redshift English: Similarly, as you load new time periods into new tables, add the new tables to the view. To signal the optimizer to skip the scan on tables that don't match the query filter, your view definition filters for the date range that corresponds to each table. 日本語: 同様に、新しい期間を新しいテーブルにロードするとき、新しいテー… 190 <iframe src="https://hatenablog-parts.com/embed?url=https%3A%2F%2Fyohei-a.hatenablog.jp%2Fentry%2F20250718%2F1752765971" title="Amazon Redshift で View に対するクエリのフィルタ条件の push down について検証してみた - ablog" class="embed-card embed-blogcard" scrolling="no" frameborder="0" style="display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;"></iframe> https://cdn-ak.f.st-hatena.com/images/fotolife/y/yohei-a/20250718/20250718091530.png Hatena Blog https://hatena.blog 2025-07-18 00:26:11 rich https://yohei-a.hatenablog.jp/entry/20250718/1752765971 1.0 100%