Increase Performance of Existing Stored Procedure

Execution Plan in SSMS

Run Stored Procedure in SSMS with “Execution Plan” enabled. SSMS will recommend index to be created.

Improve Query Statement

Convert subqueries to main queries. Note: This may not always increase performance. Have to run the both queries side by side to test.

SELECT 
     *
FROM 
     tbTable01 T1
WHERE 
NOT EXISTS( 
     SELECT TOP 1 1 FROM tbTable02 T2 WHERE T2.col02 = T1.col02 
     )
			

SELECT 
     *
FROM 
     tbTable01 T1
     LEFT JOIN tbTable02 T2 ON T2.col02 = T1.col02
WHERE 
     T2.Col02 IS NULL