Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #774

Re: Non-Relating Join Criteria

Show all headers | View raw

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

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Non-Relating Join Criteria "Fred." <ghrno-google@yahoo.com> - 2011-11-02 06:53 -0700
  Re: Non-Relating Join Criteria Hugo Kornelis <hugo@perFact.REMOVETHIS.info.INVALID> - 2011-11-02 15:08 +0100
  Re: Non-Relating Join Criteria "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-11-02 09:10 -0500

csiph-web