Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 22 Feb 2002 @ 14:12:31 GMT

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

Subj:   Re: BTEQ Question
From:   Al Czajkowski

NOTE: ******** RANT MODE ON ************

This is a continuing rant of mine against Teradata. I have made the following recommendation on several occasions to a number of different senior Teradata people.

When the query does not require any sorting, grouping, or other special work, why does the whole answer set have to be materialized in spool? I and my users want answers back. A large percentage of queries run only want to get a representative look at a few rows and the user cancels the request. With all of the talk about active data warehousing, the time to first row returned gets increasingly important. Complete materialization of the answer in spool is significantly detrimental to this. I consider DB2's implementation of this strategy to be a real plus in their bag of tricks. Anybody else agreeing that materializing the entire answer set in spool prior to returning the first row is a negative, please let your feeling be known to NCR..

****** RANT MODE OFF **********

Allen J. Czajkowski
DBA Supervisor, Data Warehousing
Ford Motor Credit Company

  <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