Snowflake, Sql, Performance, Data Science, Data Engineering.
LINEITEM that had to be re-read from cold storage during the 2nd run in the small warehouse — within query #19, #12, #1, and #3 — but in all cases it was only a small percentage of that table. Meanwhile on the XL warehouse all the warm data stayed cached on the local disk. Improving performance: