2024 Performance Improvements

The following performance improvements were introduced in 2024.

Released

Description

Impact

February 2024

Support for the the upper and lower collation specifications added to some functions.

Ability to set the the upper and lower collation specifications for some functions. The upper and lower collation specifications perform better than the ci specification for some use cases. The upper and lower collation specifications are now supported for the following functions: CHARINDEX, CONTAINS, ENDSWITH, POSITION, SPLIT, SPLIT_PART, and STARTSWITH. For more information, see Differences Between ci and upper / lower.

January 2024

Improved execution time for LIMIT 0 queries.

Reduces execution time for queries that use a count of 0 with LIMIT, which is often used by applications to return column headings and data types for query results.

January 2024

General Availability of larger warehouses (5X-LARGE and 6X-LARGE) in Microsoft Azure regions, excluding Azure Government regions.

Ability to use larger compute resources for memory-intensive queries compared to smaller warehouses.