Snowflake, Sql, Data Science, Data Engineering, Optimization.
orders_10 as select * from snowflake_sample_data.tpch_sf10.orders order by o_orderdate -- 8.9s S ; create table lineitem_10 as select * from snowflake_sample_data.tpch_sf10.lineitem order by l_shipdate -- 24s S ; Now let’s run our baseline query: select l_orderkey, sum(l_extendedprice*l_quantity) ,