Terry wrote:
> One more question. This is a pretty decent sized table. It is
> estimated to be 19,038,200 rows. That said, should I see results
> immediately pouring into the destination table while this is running?
>
SQL transactions are atomic. you wont' see anything in the 'new' table
until the INSERT finishes committing, then you'll see it all at once.
you will see a fair amount of disk write activity while its running.
20M rows will take a while to run the first time, and probably a fair
amount of memory.