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 second question: How these updates affect a data storage ? (does (b) cause physical update of f2 ?) ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
