Quick SQL Tips

union vs union all

are SQL Operators to concatenate One or more result sets. The difference between them is that Union keeps only unique records  while Union All extracts all the rows including duplicates.  When using UNION instead of UNION ALL, database server must do additional work to remove the duplicate rows