Home Update all or only where oldvalue<>newvalue?
 I'm using SQL server 2014. Which would run faster, why, and is there a way to use the analyzer to find out: update tablename set flname=replace(flname,'(','') update tablename set flname=replace(flname,'(','') where flname<>replace(flname,'(','')  No indices on flname field. I could create one though. I expect the where would filter out about 90% of rows.