The Snowflake database system includes powerful features for optimizing the performance and cost-efficiency of queries. Through testing, research, and trial-and-error, we discovered that under certain conditions, Snowflake neglects to apply an effective optimization technique known as a JoinFilter to physical query execution plans that might benefit from using it.