UNION ALL selects all records between two views including duplicates; whereas UNION takes the time to sort records in order to remove duplicates. To optimize the time a UNION query takes, using ALL may help.
UNION ALL selects all records between two views including duplicates; whereas UNION takes the time to sort records in order to remove duplicates. To optimize the time a UNION query takes, using ALL may help.