in reply to Re^2: I got confuse with INSERT
in thread I got confuse with INSERT

There is a not a (practical) programmatic way to speed up that code (without knowing more). But I think you are heading down to XY_problem Territory.

Can you give a clearer spec of what you are really trying to accomplish?
Because, I can almost guarantee that copying a set of data from one table to another is not the solution.

One dead unjugged rabbit fish later...