Sanjay Sharma

Sanjay Sharma

  • 1.3k
  • 413
  • 27.2k

Postgres - update

Jul 3 2019 5:20 AM
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  
 

Answers (1)