Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 17 Mar 2003 @ 15:55:55 GMT


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


Subj:   Re: Primary index and table space
 
From:   David Wellman

Hi,

It is true that the PI takes no physical space. I think that the difference that you're seeing may be due to 'blocking factor' (for want of another phrase). In your table which has more columns in the PI, there will be (typically) fewer rows per block, and I think you'll find that there are more data blocks used. These data blocks will occupy more disk sectors, which is the reason that you find one table has a larger CurrentPerm than the other. You should be able to check this with the Ferret / Showblocks command.


Cheers,

Dave



     
  <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