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 broadcast)--------------------------- TIP 8: explain analyze is your friend
