Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 21 Jan 2003 @ 19:38:11 GMT

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

Subj:   Re: Connectivity Tests
From:   Paul Johnson

BTEQ on Unix/MVS (dunno about Windoze) is typically faster than FastExport until volumes get well into the millions, if not tens of millions, of rows. Sorting also used to have a significant impact on the speeds of early FastExport versions. It's all due to how the data is retrieved and arranged prior to transmission back to the host...see the manuals.

I always recommend finding the cut-off point specific to each site.

In addition to it's import and export capabilities, BTEQ also has often-overlooked report formatting capabilities. IMHO, the increased use of QueryMan has reduced the knowledge of the Teradata workhorse that is BTEQ.

ITEQ is still my fave!

Paul Johnson.

  <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: 28 Jun 2020