Wednesday, 1 May 2013

Difference Between Union & Union All

Union 

  1. Union eliminates duplicate records.
  2. It is costlier compare to Union All.


Union All

  1. Union all bring all records from both table including duplicate one.
  2. It is faster than Union.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)