Re: oracle update query is taking lot of time..
From: Michael Austin <maustin_at_firstdbasource.com>
Date: Thu, 02 Apr 2009 18:35:27 -0500
Message-ID: <4_bBl.11280$%54.4161_at_nlpi070.nbdc.sbc.com>
Palooka wrote:
>
<snip>
> Just a thought though: depending, as you say, on the selectivity,
> histograms may be called for.
>
> But judging by the original query posted (the totally unnecessary
> subquery), I suspect that OP hasn't really a clue. Sorry if this sounds
> harsh.
>
> Palooka
Date: Thu, 02 Apr 2009 18:35:27 -0500
Message-ID: <4_bBl.11280$%54.4161_at_nlpi070.nbdc.sbc.com>
Palooka wrote:
>
<snip>
> Just a thought though: depending, as you say, on the selectivity,
> histograms may be called for.
>
> But judging by the original query posted (the totally unnecessary
> subquery), I suspect that OP hasn't really a clue. Sorry if this sounds
> harsh.
>
> Palooka
I have been accused of worse ("being harsh")... but would agree with the assessment. However, that being said (or typed), we can't all be guru's... :-D Received on Thu Apr 02 2009 - 18:35:27 CDT