CASE Vs UNION Which is Better in SQL

Avoid multiple UNION when you want to write better SQL query. Always better to USE case statement this improves performance. Read more.