Comment by londons_explore

Is it not normally bad practice to have 2 tables with basically identical fields and move rows between them?

Isn't that exactly what indexes were designed for?