Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 26 Jan 2012 @ 01:39:10 GMT


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


Subj:   Re: Why does size of table increase in multiples of 512 bytes
 
From:   Walter, Todd

A data block has one or more rows up to a max of the maximum block size for the table divided by the row size. One data block is stored in one or more sectors, as many as are required to hold the block. A sector is not shared among data blocks. Data blocks grow by adding sectors as needed to accommodate rows that have been added - or shrink by releasing sectors as data is deleted and a full sector becomes free.



     
  <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