post your code, can take a look at in then (p.s. not many people will know what a lakh is, it isnt used apart from in the sub continent I believe) 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. >