Return
-
Title
Migrate object is not performing in the correct order, it's create indexes before loading data -
Description
In v5.1 the migrate option for a tablespace yields a drop, create, load table, create indexes.
In v5.2 the migrate option for a tablespace yields a drop, create, create indexes, load table.
v5.1 was correct, not sure why it was changed. I have a table with 500 million rows in it. I want the data loaded quickly and then build the indexes. This is better performing.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.