What is the difference between UNION and UNIONALL?
- 5 Answers
- 11723 Views
- CarrizalSoft Technologies, CTS, I also Faced
- E-Mail Answers
Answer Posted / suresh
UNION statement effectively does a SELECT DISTINCT on the
results set. If you know that all the records returned are
unique from your union, use UNION ALL instead, it gives
faster results.
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
What are the types of database schema? : sql server analysis services, ssas
What is the use of custom fields in report?
Can we perform backup restore operation on tempdb? : sql server database administration
In which files does sql server actually store data?
What is a derived table?
How do I create a stored procedure in dbml?
What is sql server agent and what are the two modes of authentication in sql server?
What is the web service used for reporting services?
Explain the various types of concurrency problem?
How do I trace a query in sql server?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
How to truncate the log in sql server 2012? : sql server database administration
What is 4nf in normalization form?
Why use “nolock” in sql server?
What is the default Port No on which SQL Server listens?
