Snowflake, Sql, Performance, Data Science, Data Engineering.
lineitem as select * from snowflake_sample_data.tpch_sf10.lineitem order by l_shipdate; create table orders as select * from snowflake_sample_data.tpch_sf10.orders order by o_orderdate; Sorting and re-materializing in a small cold wh: 34.3s Then I created views so the original queries could find