Change locking from table level to row level
We have been locking issues when users are trying to update records . They are trying different records but from the same table.
Although each user is updating a different record, they are locking the other person because they are using the same table.
Can you please suggest as to what options have we got to resolve this issue.
Thanks,
Shailaja