Archives of the TeradataForum
Message Posted: Fri, 18 Dec 2015 @ 16:47:15 GMT
| 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.