• When you are transfering large data to new table; I suggest you create just basic structure of the table i.e. without indexes, rules etc.

    Once transfer is done you can create the required indexes depending on your queries.

    This will be much faster.

    HTH

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."