how to optimize a update query - TechRepublic
General discussion
July 1, 2005 at 03:11 AM
amitbharadwaj

how to optimize a update query

by amitbharadwaj . Updated 21 years ago

i am using sql server , and try to update a table a single field with a update query ” update table alpha set field1=’23’ where field2=’asd'”

now i have to run this kind of query 70 times/sec .Now in some cases query takes 7 ms to complete , but some time time increase to 200 ms , n i can’t afford that . so can anybody help ..how to reduce query time

This discussion is locked

All Comments