2022 Performance Improvements¶

Important

Performance improvements often target specific query patterns or workloads. These improvements might or might not have a material impact on a specific workload.

The following performance improvements were introduced in 2022.

Released	Description	Impact
November 2022	Improved performance and resilience of Snowflake applications and content.	Improved response times and availability for Snowsight pages.
November 2022	Ability to use scalar Vectorized Python UDFs in Snowpark.	Performance improvements for Python code that operates efficiently on batches of rows. Also requires less transformation logic when using Pandas DataFrames and arrays.
November 2022	Improvements for metadata queries.	Improved query execution time for small/metadata queries.
October 2022	Ability to enable Search Optimization for specific columns. (Preview)	Point lookup queries that act upon a column can be improved without incurring the expense of enabling Search Optimization for the entire table.
October 2022	Support for substring operations when using Search Optimization. (Preview)	Improves the performance of point lookup queries that use substring operations such as LIKE and ENDSWITH.
October 2022	Support for VARIANT data when using Search Optimization. (Preview)	Improves the performance of point lookup queries that act upon VARIANT data (such as JSON).
October 2022	Support for geospatial functions with GEOGRAPHY objects when using Search Optimization. (Preview)	Improves the performance of point lookup queries that use a geospatial function in a predicate.
October 2022	Improvements for Collation and BINARY columns.	Improved pruning for collations and BINARY columns, which means fewer micro-partitions must be scanned to return results.
October 2022	Improvements for hash table joins.	Improved query performance by reducing memory I/O latency in hash table equality checks.
October 2022	Improvements for DateTrunc range derivations.	Improved execution time for queries that use DateTrunc range derivation when TIMESTAMP-TZ data is a constant.
August 2022	Improvements related to Data Governance features.	More responsive Data Governance UI pages in Snowsight as well as improved query latency for tag-based masking policies.
August 2022	Improvements for window functions.	Improved rule-based optimization as well as improved query execution for outer join and filter pushdown in window functions.
August 2022	Scheduling improvements for high-concurrency workloads.	Improved query scheduling for high concurrency and lower latency workloads.
July 2022	Improved query performance using Join Elimination.	Optimized query performance through the automatic elimination of unnecessary joins, which are identified by automatically evaluating query logic.