Re: [SQL] perfomance question

On Mar 18, 2004, at 11:27 PM, sad wrote: On Thursday 18 March 2004 21:38, you wrote: Sad, what are perfomance difference bitween a) update t1 set f1 = 'x', f2 = 'y'; b) update t1 set f1 = 'x', f2 = f2; c) update t1 set f1 = 'x'; ? Not a lot. Why don't you try it? Really ! why ? :-) I forgot

Re: [SQL] perfomance question

On Thursday 18 March 2004 21:38, you wrote: > Sad, > > > what are perfomance difference bitween > > a) update t1 set f1 = 'x', f2 = 'y'; > > b) update t1 set f1 = 'x', f2 = f2; > > c) update t1 set f1 = 'x'; > > ? > > Not a lot. Why don't you try it? Really ! why ? :-) I forgot to ask the sec

Re: [SQL] perfomance question

Sad, > what are perfomance difference bitween > a) update t1 set f1 = 'x', f2 = 'y'; > b) update t1 set f1 = 'x', f2 = f2; > c) update t1 set f1 = 'x'; > ? Not a lot. Why don't you try it? -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcas

[SQL] perfomance question

hello. what are perfomance difference bitween a) update t1 set f1 = 'x', f2 = 'y'; b) update t1 set f1 = 'x', f2 = f2; c) update t1 set f1 = 'x'; ? ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if yo