2023 Performance Improvements¶
The following performance improvements were introduced in 2023.
Released |
Description |
Impact |
---|---|---|
August 2023 |
Ability to call the GET_QUERY_OPERATOR_STATS function to obtain query profile statistics. (General Availability) |
Helps to programmatically debug queries and gain insights into query performance. |
August 2023 |
Improved execution times for joins on wide build-side rows. |
Reduces execution time and improves memory management for queries matching wide rows on the build side of a join (for example, rows that include columns with long strings). |
July 2023 |
Improved selectivity and cardinality estimation. |
Uses improved plan selection to reduce execution time for queries with low selectivity. |
July 2023 |
Search Optimization Update: Support for substring search in VARIANT types. (Preview) |
Improves the performance of point lookup queries that use substring and regular expression functions against semi-structured data, including ARRAY, OBJECT, and VARIANT types. |
July 2023 |
Improved compile times for simple queries and DML statements. |
Reduces compilation times and improves memory management for simple DML statements and single-table queries with simple equality or range predicates. |
June 2023 |
Improved execution times for SELECT statements with LIMIT and ORDER BY clauses. |
Reduces execution time of some queries with long-running SELECT statements containing both LIMIT and ORDER BY clauses. |
June 2023 |
Improved execution times against secure views. |
Uses predicate pushdown to reduce execution time for queries against secure views. |
May 2023 |
Improved compile times for queries with numerous extraction expressions. |
Reduces compilation times for queries with many extraction expressions (such as those used for processing JSON). |
May 2023 |
Improved compile times for queries with numerous subqueries. |
Reduces compilation time for queries with 100+ subqueries. |
April 2023 |
Search Optimization Update: Ability to enable Search Optimization for specific columns. (General Availability) |
Point lookup queries that act upon a column can be improved without incurring the expense of enabling Search Optimization for the entire table. |
April 2023 |
Search Optimization Update: Support for substring operations. (General Availability) |
Improves the performance of point lookup queries that use substring operations such as LIKE and ENDSWITH. |
April 2023 |
Search Optimization Update: Support for VARIANT data. (General Availability) |
Improves the performance of point lookup queries that act upon VARIANT data (such as JSON). |
April 2023 |
Search Optimization Update: Support for geospatial functions with GEOGRAPHY objects. (General Availability) |
Improves the performance of point lookup queries that use a geospatial function in a predicate. |
April 2023 |
Ability to use the query acceleration service to speed up queries against tables that have Search Optimization enabled. (General Availability) |
Additional compute power provided by the query acceleration service can be combined with performance boost provided by search optimization. |
March 2023 |
Ability to use Snowpipe Streaming. (Preview) |
Enables low-latency streaming data pipelines to support writing data rows directly into Snowflake. |
February 2023 |
Ability to use the query acceleration service. (General Availability) |
Improves overall warehouse performance by reducing the impact of outlier queries. |
February 2023 |
Ability to call the GET_QUERY_OPERATOR_STATS function to obtain programmatic Query Profile statistics. (Preview) |
Helps debug queries and gain insights into query performance. |
February 2023 |
Ability to use memory-optimized warehouses. |
Memory-intensive queries can be run on Snowpark-optimized warehouses that provide 16x more memory per node and 10x the local cache compared with standard warehouses. |