Re: How can I do it optimally ?

In article <94h90l$4tr$1_at_news.ukrsotsbank.com>,   "luba_at_usb" <luba_at_usb.ua> wrote:
>
> Alex Filonov <afilonov_at_pro-ns.net> ÓÏÏÂÝÉÌ × ÎÏ×ÏÓÔÑÈ
> ÓÌÅÄÕÀÝÅÅ:94g7qt$j8k$1_at_nnrp1.deja.com...
> > In article <949c74$1ng$1_at_news.ukrsotsbank.com>,
> > "luba_at_usb" <luba_at_usb.ua> wrote:
> > > How can I do it optimally ?
> > > update Tab1
> > > set Tab1.field2=(
> > > select sum (decode (field1,1,field2,0)+decode
 (field1,2,field3,0))
> > > from Tab1 where field1 in (1,2))
> > > where field1=1 ;
> > >
> >
> > Looks like it is optimal. Is it working too long?
> >
> It is working not long , but mayby you can do it another ?
>

Any tuning (optimizing) assumes some kind of tuning goal: to make statement to run in 1 second, to have response time less than 3 seconds and so on. So if this statement runs within you goal time, it is optimal.
>

Sent via Deja.com
http://www.deja.com/ Received on Mon Jan 22 2001 - 14:15:16 CST