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

Anomy,

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.


Sanjaya



     
  <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