Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between UNION and UNIONALL?
- 5 Answers
- 13957 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
State the difference between union and union all?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
How many types of database relationship in sql server?
What is the name of the Database which IBM mainframe uses?
What is difference between commit and rollback when used in transactions?
Sql server reporting services vs. Crystal reports.
what stored procedure would you use to view lock information? : Sql server administration
What is transaction server distributed transaction?
What are the advantages of stored procedure in sql server?
What is the new security features added in sql server 2016? : sql server security
How do I change my passwords (database, LDAP, and so on) without causing an outage?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
What are different types of raid configurations? : SQL Server Architecture
how would you improve etl (extract, transform, load) throughput?
What do you understand by intent locks?
