PASS Pro Now Available

Welcome to the next evolution of PASS. Unlock exclusive training, discounts, and networking opportunities designed to accelerate your data career. Learn More >

The official PASS Blog is where you’ll find the latest blog posts from PASS community members and the PASS Board. Contributors share their thoughts and discuss a wide variety of topics spanning PASS and the data community.

The Optimizer, Statistics, and Correlated Predicates

Sometimes, a query with two predicates (filters) executes slowly, but if you remove one of the predicates it executes faster. Let’s look at why that may be, and one possible solution for it.

When you submit a query to SQL Server, the optimizer’s role is to come up with a good plan that will give accurate results quickly. One of the most important things the optimizer considers when coming up with a plan is the number of rows it expects from an operator, referred to as cardinality.

Read more


Theme picker

Back to Top