Snowflake, Sql, Performance, Data Science, Data Engineering.
not only faster because it offers more parallelism to run each query — but it also has a larger local disk cache that — in this case — is able to hold all the data scanned warm between rounds. Then with the detailed stats, you can find out what tables had to be re-read from cold-storage, and in