Imporve SQL Preformance

  • Avoid the use of WHILE loop
  • Use UNION ALL instead of UNION whenever is possible
  • Avoid using the joins of multiple tables in the where and join ine the from clause
Read More