Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 15 Apr 2003 @ 14:19:10 GMT

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

Subj:   Re: Fastexport and CSUM spool problem
From:   Michael Larkins

Hi Stuart:

I believe the reason that FastExport runs out of space is due to the fact that the AMPs build the 64K blocks to transfer the data to the client. Therefore, the rows are in SPOOL and it is building blocks at the same time. This requires more space.

My suggestion for you might be to use BTEQ. Since you are only pulling 150K rows, BTEQ will be as fast as FastExport. It is when you get closer to 500K rows where FastExport begins to really gain the speed due to the time to transfer individual rows instead of blocks (many rows).



  <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: 27 Dec 2016