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 partitioned table in Oracle?

1168

What is a dead lock in oracle?

1097

How many categories of data types in oracle?

1009

Please explain joins in oracle?

1048

What is an Oracle index?

1634

How to create additional tablespaces for an new database?

1010

How to assign values to data fields in record variables?

1011

How to check the oracle tns settings?

1031

How to generate query output in html format?

1094

What is the difference between post-database commit and post-form commit?

1165

Is java required for oracle client?

971

what is the scenario where you take the database to NoArchivelog mode?

2304

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2291

What is hash cluster in oracle?

1149

Give the different types of rollback segments.

1016