2 reads are locking table, how to workaround

Viewed 19

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?

0 Answers
Related