Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.ms-sqlserver    |    Notorious Rube Goldberg contraption    |    19,505 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 18,493 of 19,505    |
|    Hugo Kornelis to All    |
|    Re: Non-Relating Join Criteria    |
|    02 Nov 11 15:08:19    |
      01edab90       From: hugo@perFact.REMOVETHIS.info.INVALID              Hi Fred,              >My question is whether or not there can be a strong       >reason to prefer one over the other, such as impact       >on the order of evaluation.              No. Order of evaluation can and will be shuffled by the optimizer if       that can improve performance.              The only reason for using one and not the other is readability of the       query.              Note, though, that for OUTER JOINs, the two queries are NOT       equivalent!       --       Hugo Kornelis, SQL Server MVP       My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca