Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 06 Dec 2002 @ 02:31:10 GMT


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


Subj:   Re: Spool - Whole Row or Required Columns?
 
From:   Walter, Todd A

Teradata always projects out unneeded columns at every step in the plan to minimize the number of bytes moving and/or going into spool. Each successive spool could end up with fewer columns as the need for columns goes away once qualification is performed (unless they ar required in the result set of course). Note that this is one good reason not to use SELECT * unless you really mean it - if you don't need the columns in the result, don't select them and the query gets more efficient.



     
  <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: 15 Jun 2023