Voltar
-
Título
Migrate object is not performing in the correct order, it's create indexes before loading data -
Descrição
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.
-
Resolução
WORKAROUND:
None.
STATUS:
Issue fixed in version 5.5. The latest version of Toad for DB2 can be downloaded here.
-
ID do defeito
ST105935