TABLOCK for optimize transaction logging for insert select statement
I was reading that using the TABLOCK table hint
For a statement like
INSERT INTO Tab1
SELECT * FROM Tab2
can optimize transaction logging.
I don't understand this as Tablock will lock the whole table so no other
processes can access it so how would this optimize transaction logging?
No comments:
Post a Comment