Is there any way to limit SQL to locking only at the row level and never at the table level?
I have an application called RAWA that is parsing a file and writing the data from that file to a table in the database. Meanwhile, an API tries to read data from that same table. The two, however, are completely different sets of data, so there should be no need to block at the table level, only the row level.
Is there a way to force SQL NOT to block at the table level?