TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Sanjay Sharma
1.3k
413
27.7k
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
Reply
Answers (
1
)
Database synchronization
Open existing database files