Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 13 Mar 2006 @ 17:28:01 GMT


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


Subj:   PPI and Master/Cylinder Index structures
 
From:   Michael Larkins

Hi Everyone:

I have a question on PPI that I am hoping one of you has some insight. By default, Teradata builds the Master and Cylinder index entries sorted by RowHash value (highest) within TableID for each cylinder and block. This makes it easy and quick to find any row hash within the table.

When PPI is used and the data is sorted by the partition value, the Master and Cylinder index entries must be arranged differently (at least to a degree). Is there now some entry or combination of TableID or Row Hash to include the partition id to allow quick access to any particular Row Hash for a partition?

With that asked, I am mainly wondering for access using a USI without the partitioning value where it has traditionally stored only the RowID of the base data row. I appreciate any light that you might provide to help me better understand or direction for a particular Teradata document that contains this information.


Thanks in advance,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor



     
  <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