home bbs files messages ]

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