UNION provides only distinct values as output whereas UNION ALL provides

what is the difference between UNION AND UNIONALL

Question Posted / k

Answer Posted / k

UNION provides only distinct values as output whereas UNION
ALL provides all values.
So UNION ALL seems to be faster than UNION.

Is This Answer Correct ?

25 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is instant client oracle?

973

Can I create users through internet explorer in oracle 10g?

1020

What is a static data dictionary in oracle?

1025

What is a dynamic performance view in oracle?

949

What is an anonymous block?

1158

What is the dynamic sql in oracle?

1008

How to use "in out" parameter properly?

1000

What happens to the current transaction if the session is killed?

927

How to resolve the ORA-39133 error in Oracle?

1033

What is the relationship among database, tablespace and data file?

929

Explain the use of consistent option in exp command.

974

What is proxy method?

931

How to estimate disk space needed for an export job?

992

How to start an oracle instance?

953

How to sort the query output in oracle?

969