T-Sql Update Problem

Update Inv01 Set PrintStat = 1 where Inv_No = '335059'

This query taking too 开发者_如何学Pythonmuch time even nine minutes finished.Please help me

Index your Inv01 table on the Inv_No column, that's the only way you're going to speed it up; there's no way to improve the query itself.