My colleague who is a dba help me investigate the issue, she found that the destination table has primary key which is a composite index including 3 column and about...

Thanks Grant and Eric for your information.

I have a supplement that originally the tableA table has no records, and it is inserted data from only another table and 13 millions...

Hi sgmunson and friends,

Your approach is ok, but I have a request that how to move the last row in your query to the first row position. Actually this is...

Thank you so much, sgmunson

It has worked as my expectation :-). In the example above, I just simulated simple data to describe my problem. Tomorrow I will apply your idea...

Hi friends,

Thank you very much for your suggestions, they are helpful for me.