Timeline for Can you explain this execution plan?
Current License: CC BY-SA 4.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 9, 2019 at 8:22 | history | edited | Paul White♦ | CC BY-SA 4.0 | Updated links |
| Nov 13, 2018 at 23:34 | history | edited | CommunityBot | replaced http://sqlblog.com/blogs/paul_white/archive/2012/01/18/dynamic-seeks-and-hidden-implicit-conversions.aspx with http://web.archive.org/web/20170303101108/http://sqlblog.com/blogs/paul_white/archive/2012/01/18/dynamic-seeks-and-hidden-implicit-conversions.aspx | |
| Apr 13, 2017 at 12:42 | history | edited | CommunityBot | replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/ | |
| Mar 14, 2012 at 22:51 | vote | accept | Andrew Savinykh | ||
| Mar 14, 2012 at 8:28 | history | edited | Martin Smith | CC BY-SA 3.0 | added 422 characters in body |
| Mar 14, 2012 at 8:22 | history | edited | Martin Smith | CC BY-SA 3.0 | added 422 characters in body |
| Mar 12, 2012 at 16:57 | history | edited | Martin Smith | CC BY-SA 3.0 | added 1524 characters in body |
| Mar 12, 2012 at 15:40 | comment | added | Martin Smith | @SQLKiwi - Thanks. That makes sense. Hopefully I will have figured out some of the missing bits before then. | |
| Mar 12, 2012 at 14:59 | comment | added | Paul White♦ | @MartinSmith 60 is indeed for a comparison with NULL. The range boundary expressions use NULL to represent 'unbounded' at either end. The seek is always exclusive i.e. seek Start: > Expr & End: < Expr rather than inclusive using >= and <=. Thanks for the blog comment, I'll post an answer or a longer comment in reply in the morning (too late to do it justice right now). | |
| Mar 12, 2012 at 12:50 | comment | added | Martin Smith | @MarkStorey-Smith - he says 62 is for an equality comparison. I guess 60 must mean that instead of > AND < as shown in the plan you in fact get >= AND <= unless it is an explicit IS NULL flag maybe(?) or maybe the bit 2 indicates something else unrelated and 60 is still equality as when I do set ansi_nulls off and change it to c2 = null it still stays at 60 | |
| Mar 12, 2012 at 12:39 | comment | added | Mark Storey-Smith | I can't spot anything in Paul's article that explains the difference in the flags for [Expr1012]. Can you deduce what the 60/10 signifies here? | |
| Mar 12, 2012 at 11:49 | history | answered | Martin Smith | CC BY-SA 3.0 |