Hi
I have table which has over 20million rows in it. In Source System, many rows (over 30%) are updated every day. I am using Upsert method in datastage. It is taking more time for upsert.
Is there any other method we can use to get the performance?
Thanks
Update 20m rows table
Moderators: chulett, rschirm, roy
More time than what?
20 million is not that large. Let's start with this. How are you determining which records have been updated? Do you also need to insert new records or are we literally just talking just inserts? Are the columns in your update's where clause indexed?
20 million is not that large. Let's start with this. How are you determining which records have been updated? Do you also need to insert new records or are we literally just talking just inserts? Are the columns in your update's where clause indexed?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: