Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 21 Mar 2006 @ 12:47:21 GMT


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


Subj:   Re: Performance issue on a huge table..
 
From:   OHara, Daniel

Hi Victor,

  Having said that, I would probably tend to think that we do not "need" to do things like that, the optimizer should probably select the appropriate PI values before copying the data to the spool file. Don't know whether you agree with this."  


Even if the optimizer only stores the PI in spool it will still have to read all the blocks from the full table. The Disc I/O saved in reading a table/index only containing PIs may still be beneficial.


Daniel



     
  <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