Imporve SQL Preformance

sql sqlserver

• 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

Reference:

https://www.sqlshack.com/3-ways-to-improve-t-sql-performance/

Written on May 16, 2022