>>I'm not really sure what SDT Reindex does, but I hope it does complete rebuild of indexes.
>
>Hope doesn't replace reading the code... er, does SDT come with source code? If it does, just look for Index On in Code References.

I've asked my colleague. He told me that it does complete rebuild of the indexes.
I'm running it now before trying another test.

>
>>Right now the process is still running on my PC. The first stage (LoadNewTRans) finished successfully in 43 minutes.
>
>Wow... this must be one beast of a database, or a brand new 200MHz machine :)

We need to update ~20 different tables using some complex logic...