Below is the size of the tableA
name rows reserved data index_size unused
TableA 49132 19352 KB 8464 KB 10280 KB 608 KB
Select * from tableA - took 00:00:01
Update query - took 00:00:01
Adding additional indexes will fix the issue? or providing locking hint in the queries will be the best option to fix it?