Home Forums SQL Server 2008 T-SQL (SS2K8) Performance Opinion RE: Performance Opinion
Umer Akram
SSC-Insane
Points: 22209
More actions
December 13, 2013 at 12:20 am
#1673171
if there is large data set in the #Temp table, all you find in the query execution plan is "tableScan" for #Temp table, If you need to increase the performance then you need to index the temp table as well.