Execution plan of a server query. As you can see in the above execution plan, SQL Server has highlighted a missing index that it thinks would help our query improve.

What this means is that the best execution plan for a parameter value of 1 or 2 would be for SQL Server to do an index seek operation against the SupplierID column (which happens to be indexed ...

SQL Server has an optimizer that usually does a great job of optimizing code for the most effective execution. A query execution plan is the breakdown of how the optimizer will run (or ran) a query.

This not only clutters T-SQL code, but forces the execution plan to use an index scan. In SQL Server 2022, we have a new IS DISTINCT FROM and IS NOT DISTINCT FROM syntax that not only handles both ...