Re: Performance improvment -loop update.

From: DA Morgan <>
Date: Thu, 24 Aug 2006 09:03:31 -0700
Message-ID: <>

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
(replace x with u to respond)
Puget Sound Oracle Users Group
Received on Thu Aug 24 2006 - 18:03:31 CEST

Original text of this message