What is the difference between UNION and UNIONALL?
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
How to get the definition of a stored procedure back?
Characterize join and name diverse sorts of joins?
How to create an identity column?
Is null in sql server?
What is the difference between functions and stored procedures?
Explain activity monitors
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
What is clustered index
How to delete database objects with "drop" statements in ms sql server?
How can we check the sql server version?
How to create hyperlink from returned sql query ?
How does using a separate hard drive for several database objects improves performance right away?
What is default constraint?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas