Hi,
wht are the possible ways to improve performance when doing Oracle table updates.
i thought of Indexes, splitting up inserts and updates..
let me know any ways to improve the performace, my update job is taking longer time to update the records
any help is appreciated.
thanks
Ways to improve performance for table updates
Moderators: chulett, rschirm, roy
Ways to improve performance for table updates
"Attitude always and almost determines the altitude of your Life"
Re: Ways to improve performance for table updates
Delete and then bulk load can be a option. Again if Oracle you can truncate a partition and load a new one if the load is on a monthly basis. Actually there are a lot of ways. Please provide more info on the background.kool78 wrote:Hi,
wht are the possible ways to improve performance when doing Oracle table updates.
i thought of Indexes, splitting up inserts and updates..
let me know any ways to improve the performace, my update job is taking longer time to update the records
any help is appreciated.
thanks
Thanks
Avi
Avishek Mukherjee
Data Integration Architect
Chicago, IL, USA.
Data Integration Architect
Chicago, IL, USA.
Re: Ways to improve performance for table updates
avi21st wrote:Delete and then bulk load can be a option. Again if Oracle you can truncate a partition and load a new one if the load is on a monthly basis. Actually there are a lot of ways. Please provide more info on the background.kool78 wrote:Hi,
wht are the possible ways to improve performance when doing Oracle table updates.
i thought of Indexes, splitting up inserts and updates..
let me know any ways to improve the performace, my update job is taking longer time to update the records
any help is appreciated.
thanks
Thanks
Avi
we have a dimension which has a load_date column, so almost all the rows of the dimension gets updated daily, its a diaily run.
"Attitude always and almost determines the altitude of your Life"
Re: Ways to improve performance for table updates
What is the database?kool78 wrote:avi21st wrote:Delete and then bulk load can be a option. Again if Oracle you can truncate a partition and load a new one if the load is on a monthly basis. Actually there are a lot of ways. Please provide more info on the background.kool78 wrote:Hi,
wht are the possible ways to improve performance when doing Oracle table updates.
i thought of Indexes, splitting up inserts and updates..
let me know any ways to improve the performace, my update job is taking longer time to update the records
any help is appreciated.
thanks
Thanks
Avi
we have a dimension which has a load_date column, so almost all the rows of the dimension gets updated daily, its a diaily run.
Avishek Mukherjee
Data Integration Architect
Chicago, IL, USA.
Data Integration Architect
Chicago, IL, USA.
Re: Ways to improve performance for table updates
Oracle 10gavi21st wrote:What is the database?kool78 wrote:avi21st wrote: Delete and then bulk load can be a option. Again if Oracle you can truncate a partition and load a new one if the load is on a monthly basis. Actually there are a lot of ways. Please provide more info on the background.
Thanks
Avi
we have a dimension which has a load_date column, so almost all the rows of the dimension gets updated daily, its a diaily run.
"Attitude always and almost determines the altitude of your Life"
Re: Ways to improve performance for table updates
Delete the updated records...then bulk load both insert+updates to the database works faster than updates. Else put them in Sequential file and do a Oracle import (SQL wrapped in shell script). What is the data volume and the time takenkool78 wrote:Oracle 10gavi21st wrote:What is the database?kool78 wrote:
we have a dimension which has a load_date column, so almost all the rows of the dimension gets updated daily, its a diaily run.
Avishek Mukherjee
Data Integration Architect
Chicago, IL, USA.
Data Integration Architect
Chicago, IL, USA.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: