Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 10 Mar 2004 @ 03:08:41 GMT

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

Subj:   Re: More than one table in a cylinder?
From:   Sanjaya Nagabhushan


Yes, More than one table can co-exist on a particular cylinder. It is a data block that will exclusively contain rows for only one subtable. Also a cylinder can be used for storage of PERM or TEMP or SPOOL data but not a combination.

A SRD (Subtable Reference Descriptor) exists on the Cylinder Index (CI) for every table that lives on a cylinder. SRD lists the sub-tree of data blocks for a particular table on a particular cylinder.


  <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: 27 Dec 2016