Archives of the TeradataForum
Message Posted: Tue, 21 Jan 2003 @ 19:38:11 GMT
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!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|