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

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


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

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


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
×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Thanks for your registration, follow us on our social networks to keep up-to-date