In the documentation, they have mentioned that read operations are allowed during optimize operation, but nothing is mentioned about write and DML operations. If it is possible, can some one provide the link to the documention for same?
In the documentation, they have mentioned that read operations are allowed during optimize operation, but nothing is mentioned about write and DML operations. If it is possible, can some one provide the link to the documention for same?
Share Improve this question asked Mar 7 at 8:35 Shailendra KirtikarShailendra Kirtikar 474 bronze badges1 Answer
Reset to default 1Delta format is designed to handle concurrent operations. While OPTIMIZE is running, other write and DML operations (like INSERT, UPDATE, DELETE, MERGE) can generally proceed. Delta's transactional guarantees ensure that these concurrent operations are handled correctly, maintaining data consistency.
NOTE: However, heavy concurrent write operations during an optimize operation could increase the time it takes to complete the optimize operation.
发布者：admin，转转请注明出处：http://www.yc00.com/questions/1744941613a4602358.html
评论列表（0条）