Team,
I have following SQL
UPDATE dbo."UnitStatement" as TblNav
SET "NAV" = TblNav."NAV"
FROM dbo."NAV" as TblNav
WHERE TblUnit."FundId" = TblNav."FundId"
AND TblUnit."UnitDate" = TblNav."Date"
record # unitstatement - 2211664
record # nav - 213172
I have following this to understand.
1. in realife how much time it should take? ( I cancelled it after 2+ hrs)
2. I apply index on TblUnit."FundId" & TblNav."FundId" ( But still not able to boost the perfromance)
Please help to boost the performance of above query