How to reduce worktable logical reads?

804 views Asked by At
update  #temp_Or_GetPendingOrdersList
set     ApprovedOn = 
            dbo._UD_GetDate(dbo._UD_ConvertToCompanyTime(@HHA,#temp_Or_GetPendingOrdersList.ApprovedDate,#temp_Or_GetPendingOrdersList.branchid))
            + ' ' +dbo._UD_GetTime(dbo._UD_ConvertToCompanyTime(@HHA,#temp_Or_GetPendingOrdersList.ApprovedDate,#temp_Or_GetPendingOrdersList.branchid))
from    HConfigurations2 with(nolock), TimeZones with(nolock)
where   #temp_Or_GetPendingOrdersList.branchid = HConfigurations2.HHA_BRANCHID
        and HConfigurations2.TIME_ZONE = TimeZones.ZONE_ID
        and HConfigurations2.HHA_ID = @hha

There is a update statement in a stored procedure which has very high worktable logical reads. How to reduce them?

enter image description here

0

There are 0 answers