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

How would you best determine why your MVIEW couldnt FAST REFRESH?

1511

How to define a procedure inside another procedure?

629

What is meant by an index?

718

What is the best way to do multi-row insert in oracle?

652

What is an oracle transaction?

666

How to use attributes of the implicit cursor in oracle?

651

how to join query for one source type is oracle another source type is sql server ?

2083

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2006

What is a tns service name?

616

How to grant create session privilege to a user in oracle?

649

What are the differences between date and timestamp in oracle?

653

How to define an oracle cursor variable?

661

Describe varray?

687

What do you mean by merge in oracle and how can you merge two tables?

598

How do I reset a sequence in oracle?

708