Does DTW lock the entire file sale OITM master data file while updating say default warehouse?
This because, In case if there are over 100K items, the file OITM could stay locked for a long period of time. Locked form Updates I mean.
Or DTW is slow due to validation necessary before each item is updated into OITM table?
It may seem like it has updated the entire OITM table, in reality validation is occurring for each of the OITM record.
Record level lock is okay but not table level lock OITM.
Your especially developer level expertise is appreciated. Have you ever seen at SQL table level? the locks while DTW is running?
Thank you very much,