You don't show us the code, you don't tell us what version,platform, you don't tell us how much time it takes and you don't tell us how much time ti should take. Sorry, the crystal ball is broken, come back in 3 weeks. ps: 1 lakh is one hundred thousand. Raj On 9/28/05, manoj.gurnani@xxxxxxxxxxxxx <manoj.gurnani@xxxxxxxxxxxxx> wrote: > > > Hi, > I've a cursor which retrieves about 3 lakh recs from a table.(master) > based on column value retrieved from cursor for each rec,there are other > tables (detail) to be updated. > The detail tables have large volumes of data. > the question is how can the performance be improved to achieve the desired > result. >