Below is the size of the tableA

namerowsreserved data index_sizeunused

TableA49132 19352 KB 8464 KB 10280 KB608 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?