Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag OR Rss

   Items 1 to 1 of 1   
 

Whether to use UNION or OR in SQL Server Queries

Recently I came across with an article on DB2 about using Union instead of OR. So I thought of carrying out a research on SQL Server on what scenarios UNION is optimal in and which scenarios OR would be best. I will analyze this with a few scenarios using samples taken from the AdventureWorks database  Read more...
By Additional Articles 2011/07/06 | Source: SQL Server Performance | Category: t-sql
Rating:  Rate this |   Briefcase | 5,904 reads
   Items 1 to 1 of 1