RE: Customize SQL Query – SQLServerCentral

Ten Centuries

Points: 1062

July 13, 2009 at 1:40 am

Hi,

Even when i execute below Simple Query its take more than 20 minutes

update Auditdata set tatcalltype = 'null' where tatcalltype is null

tatcalltype datatype is varchar

i put the index on tatcalltype column

Cookies on SQLServerCentral