Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SS7,VB6,VBS
Expertise: beginner
Apr 29, 2000

The ALL clause can speed up UNION statements

If you omit the ALL clause in an UNION statement, SQL Server must delete duplicate values, which in turn means that it has to sort the two sub-resultsets that have to be combined. Needless to say, this is a time-consuming operation.

In most cases, you decide whether to use the ALL clause depending on your application requirements, and therefore you have no choice. However, if you are 100% sure that the two sub-resultsets have no duplicate rows, you can sensibly speed up execution by adding an explicit ALL clause, as in:

SELECT Name, State FROM USCustomers
UNION ALL
SELECT Name, Country FROM AbroadCustomers
Francesco Balena
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date