Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 18 Dec 2015 @ 16:47:15 GMT

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

Subj:   Re: Master Index and Cylinder Index
From:   Anomy Anom

<-- Anonymously Posted: Friday, December 18, 2015 11:45 -->

Changes to each AMP's file system Master index and Cylinder indexes are written to disk for persistence. Master index is read into memory (cache) at start-up and is always kept in memory; Cylinder indexes are read on demand but generally remain in cache also, since they tend to be very heavily accessed.

  <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: 24 Jul 2020