Snowflake, Sql, Performance, Data Science, Data Engineering.
order by session_id; Session 4 was 18% faster than session 0: Pruning wins. Lessons learned You can use the new get_query_operator_stats() to get deep stats for your queries. Within these deep stats you can find information like the # of partitions scanned by each query. Storing tables ordered by