2026 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 2026:

Released

Description

Impact

January 2026

Improved pruning for join queries with inequality predicates. For example, the following join query uses the > operator in an inequality predicate:

SELECT *
  FROM employees e, managers m
  WHERE e.employee_id = m.employee_id AND
        e.salary > m.salary AND
        m.level = 'M5';
Copy

For this query, Snowflake prunes micro-partitions from the employees table where all salaries are below the lowest M5 manager salary.

Improves the performance of join queries that have inequality predicates.
Language: English