Snowflake, Sql, Data Science, Data Engineering, Optimization.
current_timestamp() -- avoids using the query results cache from lineitem_10 join orders_10 on l_orderkey = o_orderkey group by 1 order by 2 desc limit 10 -- 5.2s ; The execution graph shows a join between tables 5.2 seconds on a Small warehouse — now we can help Snowflake optimize it by adding