Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 28 Mar 2001 @ 11:51:31 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Database Design
From:   David Wellman


A few thoughts on this...

If you've got a row length that large then I'm guessing that you've got one or two columns which are big VARCHARs. Teradata will only store the necessary amount of data - i.e. 100 bytes of data in a VARCHAR(20000) will only take up 102 bytes. So you may not have that much of a problem anyway.

Spool space usage is not dependent directly on the row length, only on the size of the columns from the row that Teradata needs in the spool file to answer the query (i.e. it doesn't just copy the entire row).

If you've got rows which really are that long, then you'll be doing a lot of physical I/O because (I think) Teradata will put each row into a separate block (because this is treated as a large row).



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