How to load from a staging table without introducing a lock?
How to load from a staging table without introducing a lock? We have a staging table, and would like to insert the whole table into the main Fact table without lock. Currently we are just using Insert .. Select statement. From the Manual and in practice, if there is an existing Select (S Lock) on the fact table longer than the timeout (300 seconds by default), the insert would get lock error. We have investigated to use COPY command but it is very restricted to load data from flat files or other database. Is there a way to insert data between tables without introducing/acquiring an I Lock? Thanks