devxlogo

Use UNION ALL Instead of UNION

Use UNION ALL Instead of UNION

To improve query speed, use the UNION ALL statement. UNION ALL looks for and discards duplicate rows in the result set, whereas the UNION statement does not.

devx-admin

Share the Post: