Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Although I was able to find the definition of predicates online at MSDN:

Is an expression that evaluates to TRUE, FALSE, or UNKNOWN. Predicates are used in the search condition of WHERE clauses and HAVING clauses, the join conditions of FROM clauses, and other constructs where a Boolean value is required.

I have been unable to find the definition of what a residual predicate is. What is a residual predicate?

share|improve this question
Try this question on Stack Overflow – Gaius Apr 17 '11 at 15:14
up vote 6 down vote accepted

A residual predicate is one that has an hidden extra cost because the predicate has to be tested again on every combination of rows that is fetched. Probe Residual when you have a Hash Match – a hidden cost in execution plans

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.