renaming table issues?

[raiboq]

Hello friends,
I want to load data into a temp table and then rename in to the original table name to keep them down time to a minimum but I do not think the table is being indexed properly after I rename it. What is the best method to do such a process or what I might be doing wrong?
Thanks. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[sierra]

CREATE INDEX is internally mapped to ALTER TABLE, and every ALTER TABLE recreates the full table, including copying the data and creating all indexes. So make all changes with one ALTER TABLE statement. Not every change in its own statement.

The best way to do might be:

Create a new table without indexes.
Load the data into it.
Alter the table, adding all indexes you want to have on it.
Rename the old table to something.
Rename the new table to the old name.

Load the data before creating the indexes because the index creation on existing data is mostly much faster than index creation on the fly. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --