|
|
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.
| |