Snowflake, Sql, Data Science, Data Engineering, Optimization.
sum(l_extendedprice*l_quantity) , current_timestamp() from lineitem_10 where l_orderkey in (select o_orderkey from orders_10) group by 1 order by 2 desc limit 10 But Snowflake did not eliminate that redundant semi-join in my experiments. Don’t worry too much about it: The team is aware and working