Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 06 Jul 2011 @ 11:32:31 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Fastload has no worktable and logtable?
From:   Dieter Noeth

Anomy.Anom wrote:

  If fastload doesn't make use of worktable, then will it make use of spool to sort the rows on amp?  

The target table *is* the worktable:

In the 1st loading phase rows are stored unsorted in a special subtable (subtable id 1025 instead of 1024).

The "end loading" sorts the data in-place (AFAIK without additional spool) and moves the sorted data into subtable 1024.

You can actually watch that process when you run "showb /l" on the table in Ferret repeatedly during a FastLoad.


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023