Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 18 Dec 2015 @ 19:52:51 GMT


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


Subj:   Re: Master Index and Cylinder Index
 
From:   Walter, Todd

The Master Index is stored in internal PDE memory. It does not exist as a disk structure, is created at system startup and is maintained only in memory (no writes for changes).

The cylinder indexes are stored as the first part of each cylinder on disk (hasn't actually been a cylinder for a long time, now just a file system allocation unit). The CIs are cached in FsgCache and are managed there like other file system structures using the MRU algorithm for deciding what stays in cache. If changed, changes are logged in the WAL log and when it is time to flush from the cache they are also written back to disk to maintain the persistent version there.



     
  <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