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

Explain the use of record length option in exp command.

560

How to start your 10g xe server?

596

What are a collation and state the different types of collation sensitivity?

551

How do we create privileges in oracle?

588

How are extents allocated to a segment?

580

Is a rollback possible to any savepoint?

556

What is data file?

619

How to install oracle database 10g xe?

562

What is null value in oracle?

638

How to define and use table alias names in oracle?

509

How to synchronize 2 schema's objects?

1690

How to drop a stored procedure in oracle?

592

How to sort output in descending order in oracle?

578

What do you mean by group by clause?

563

How do I find the database name in oracle?

601