Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Using the Union Statement - SQL School Video Expand / Collapse
Author
Message
Posted Tuesday, March 24, 2009 12:36 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Monday, September 15, 2014 9:16 AM
Points: 6,784, Visits: 1,895
Comments posted to this topic are about the item Using the Union Statement - SQL School Video

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #682098
Posted Tuesday, March 24, 2009 8:16 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, April 14, 2014 12:18 PM
Points: 69, Visits: 69
It might be worth noting that when using UNION, more work must be done to find the duplicates rows. We have found that using UNION ALL returns data much faster when large result sets are being returned and you know that the data being returned by the queries are mutually exclusive.
Post #682386
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse