I'm a little confused.
I have 2 scripts running
INSERT INTO DB.TABLE1
SELECT * FROM TABLEX
and
INSERT INTO DB.TABLE2
SELECT * FROM TABLEX
These running at the same time get a table lock.
But why can't 2 processes read at the same time, what can I do?