Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 05 Jul 2006 @ 18:11:19 GMT


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


Subj:   Re: Subtables and Secondary Indices
 
From:   Pandey, Vivek

1) If we are creating the secondary index by default subtable will be created, my doubt is whether the subtable will be created for each amp or it will be created for each table.

All the tables including subtables & basetables reside on all the amps. They can be empty but still have their table header in each amp.

2) In the Unique Secondary Index - the subtable will be created it will be holding the details about the base table, my doubt whether where it will be stored, it will be stored in the same amp or different amp.

The USI subtable row contains the USI value & the base row-id. Of course it is hashed in the USI value and therefore when the USI & PI values are not hash synonyms the USI sub-table row and the base table row will reside on the different amps.


Hope that helps!



     
  <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: 15 Jun 2023