This processing is automatic and is apparent when viewing the execution plan in SQL Server Management Studio via the new Parallelism operator. Another new feature is partition elimination.

In SQL Server 2022, we have a new IS DISTINCT FROM and IS NOT DISTINCT FROM syntax that not only handles both NULL and non-NULL values, but allows the execution plan to use an index seek ...