Re: Performance improvment -loop update.

yogi wrote:
> Hi all,
> [Quoted]
> Please help me in tuning this query...

[Quoted] You've got to be kidding. I help a lot of people and try to keep an open mind but your question, as I read it, is offensive.

[Quoted] You provide no information about the system No SLA
No Explain Plan
You have a cursor loop which has been repeatedly sited as inefficient compared with array processing.

[Quoted] And then you want someone else to do what you are paid for? And urgently too?

[Quoted] No! Perhaps I just need some coffee. But if you are not qualified to do your job then quit.

[Quoted] Now I'll go get some coffee. ;-)

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org